Question
Evonsys
Evonsys
US
Evonsys
Posted: Apr 4, 2023
Last activity: Apr 4, 2023
Last activity: 4 Apr 2023 10:56 EDT
Closed
Can Bot be able to automatically move to next row in excel and copy data?
Hi,
I have a requirement where Bot has to set data in Excel for 28 rows. Is there any possibility that it can move automatically to the next row and set the data?
Could anyone please suggest?
Thanks,
***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
@harshavardhinip The connectors available for Excel allow you to do this. The GetCellValue method allows you to get the value of a cell. The SetCellValue method allows you to set the value of a cell. Both of these methods take the row and column as parameters to help you determine where you wish to read or write data from or to. If you are having a specifc issue or question with one of the connectors, please upload your sample solution and I can certainly take a look at it for you. In your case, I would probably use a ForLoop to output what your row should be for a given iteration. You would set the Initial and Limit values of the loop accordingly (Excel rows start at row 1 which is typically your header row). The Index property of the ForLoop would be used as the Row parameter in your SetCellValue method.