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
I am also having similar requirement, please help
Hi, The issue is there might be some empty columns without data. First delete those column and then user get all cells command to get all data from excel.
Happy Automation!!!
Hello Mandar,
It sounds to me that you may have the "Contains Header" option ticked on one of the Open Spreadsheet commands. If you untick this option it should get rid of the error. If you actually need this option ticked due to the existance of a header then you can use something such as the following:
Excel: Open Spreadsheet "$Prompt-Assignment$". ActiveSheet: "Default". Session: Default
Excel: Get All Cells Session: Default
Start Loop "Each row in an Excel dataset of Session: Default"
If $Counter$ Greater than or Equal To(>=) "2" Then
Comment: Please enter the conditional commands here.
End If
End Loop
I hope you find this helpful.
Cam
Attach sample spreadsheets that generate the issue. Show some screenshots of the actual result.. and some sort of table of what you expect.