Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data comparision with the Excel spread sheets

Rama_RajuGK
Level 3

‎07-02-18 04:35 PM

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
0 Likes
2 REPLIES 2

Denis__Dennehy
Level 15

‎07-02-18 05:17 PM

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.  
0 Likes

Rama_RajuGK
Level 3

‎07-02-18 05:35 PM

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.  
0 Likes