Hello - I need help please. The overview of what I am getting the bot to do is:
Read an Excel file
If a cell “RegistrationStatus” is updated with “Proceed” then carry out activities to generate a reference number
Paste the reference number back into the Excel cell “ClaimNo.”
Write in “RegisterDate” cell the date today
Write in “RegisteredBy” cell the user ID of the system account
Overwrite the “RegistrationStatus” with the word “Done”
Save the workbook
Move on to the next row that has status “Proceed”
I am having problem with the WRITE CELL formula… What I have is this:
“L”+dtOutputCapitaland.Rows.IndexOf(row).ToString
It is telling me that L0 does not existing. “L” being the “ClaimNo.” column and “dtOutputCapitaland” being the variable of my Excel. I have tried to change it to:
Hi @Sophie_D !
Welcome to UiPath Community
Do you want to start writing at the cell L1 or L2 ?
To write starting from cell L1, write: “L”+(dtOutputCapitaland.Rows.IndexOf(row)+1).ToString
To write starting from cell L2, write: “L”+(dtOutputCapitaland.Rows.IndexOf(row)+2).ToString