Working with two excel sheets at the same time

Hi,
I have a scenario where I have to open two excel sheets and compare the data , if it matches then need to create another excel sheet with additional data.

For example:
excel1
ID,Name , Address

excel2
ID,Name,Age

Need to find ID from excel1 to excel2 and if it matches then need to create excel3 which contains
ID,Name,Address,Age

I have tried to use GET ALL CELLS excel command using different session names but while extracting data from second sheet I got below error:

The Excel spreadsheet contains any/all of following:
- Empty header(s)
- Duplicate header name(s)

- Invalid cell range

Please let me know best way to get this done?

thanks for your help in advance!!!

Comments

Sign In or Register to comment.