For each and write cell

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:

“ClaimNo.”+dtOutputCapitaland.Rows.IndexOf(row).ToString

But it’s not working as well :frowning:

Helpy help please! Much thanks in advance.

1 Like

Hi @Sophie_D !
Welcome to UiPath Community :grinning_face_with_smiling_eyes:
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

2 Likes

Hi @Sophie_D
try like this
“L”+(dtOutputCapitaland.Rows.IndexOf(row)+2).ToString if there are headers in excel

1 Like

Thanks you sooooo much!! It worked :upside_down_face:

1 Like

Heya, super thanks! It’s worked :slight_smile:

1 Like

That’s great !! Happy automation :grin:
Don’t forget to mark your topic as solved so we focus on unresolved topics :wink:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.