Working with two excel sheets at the same time

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:
ID,Name , Address


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

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!!!


Sign In or Register to comment.