Write to the next empty cell

Hello guys! :smile:
I need to write new information on the next blank lines with each run of the robot.
How can I do this?
Regards

1 Like

Hey @danielle.freitas,

You need to use the below activity which writes in a next new row.

Hope this helps

#nK

Thanks !!
but that doesn’t work because the file extension is xlsm

1 Like

Oh is it, I think it should work.

Could you please share the file to check, will be easy to debug.

Else, you need to follow a different approach using read range.

Could you please confirm that either read/write range works for your case.

#nK

Hi @danielle.freitas

You will definitely be able to use read range and write range with excel application scope (Macro Setting: Enabled All), all the information becomes a part of a data table variable, then you can add ‘Add Data Row’ activity to add new info on the next row with each run of the robot.

Please see below:

Sample data: I used the same headers as shown above :slight_smile:
image

Then I used below code snippet:

image

Hope this helps!!

1 Like

Thank you!

1 Like

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