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

  • @Mandar said:
    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!!!

    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

Sign In or Register to comment.