Data comparision with the Excel spread sheets

[Rama_RajuGK]

Hi All, I have 2 spreadsheets and I need to compare both the spread sheets based on the match[coumn1 in both the sheets] I need to write some of the columnar details into new spread sheet. Final output spread sheet3 will hold the Column1 & Column2 from spread sheet1 , Column5, Column 8 from spread sheet2. Now I am dumping both the sheets into 2 different collections but when I go for the match I have a problem as I both the input spread sheets has 1000 rows which is consuming lot of time - can you please let me know how can I overcome this latency. Regards, Ram

[Denis__Dennehy]

It sounds like you need to spend a bit of time getting familier and playing about with with the MS Excel VBO.  The actions that will be your friends most will be the read worksheet as collectdion and write collection actions - especially the range versions of them.  

[Rama_RajuGK]

Thanks Denis for the reply - in my case I am reading the both the worksheets as 2 different collections but when the comparison takes place it is minting lot of time as both the spreadsheet data will not be same always - here I need to compare data every time from both the sheets.