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