I need to write new information on the next blank lines with each run of the robot.
How can I do this?
You need to use the below activity which writes in a next new row.
Hope this helps
but that doesn’t work because the file extension is xlsm
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.
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
Then I used below code snippet:
Hope this helps!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.