Robotic Process Automation (RPA)

Robotic Process Automation (RPA)

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
  • 1.  Reading rows in Excel

    Posted Wed March 02, 2022 06:50 AM
    Hello,
    I have a excel file in which it is 51 columns and 4 rows (one row for headers). I'm trying to map whole table and set the values on webpage but there is a problem. Robot sets values only from last row of the table. What is the reason for this action? Do you know any solutions to this problem?

    Thank you in advance for your answers.

    Best regards
    Mateusz Ryszawy

    ------------------------------
    Mateusz Ryszawy
    ------------------------------


  • 2.  RE: Reading rows in Excel

    Posted Wed March 02, 2022 01:54 PM
    Hi, please share the relevant parts of your bot script.

    ------------------------------
    Joba Diniz
    Product Manager
    IBM
    ------------------------------



  • 3.  RE: Reading rows in Excel

    Posted Fri March 11, 2022 11:50 AM
    Edited by Martin Medina Fri March 11, 2022 11:50 AM
    It would help us if you could provide us some clarity on the issue. Is this a mapping or setting issue?

    • Have you confirmed that you were able to successfully map the entire table to your variable? Or was it just the last row?
    • Are you attempting to set the entire table at once? If that's the case, I would recommend looping through each row to insert.

    Hope these help point you in the right direction