How do I get it to write a string under append range in my Excel file during the loop?

Hello, I have a problem with my Excel spreadsheet. I’m extracting data from a multi-record webpage to Excel. Each time a data set is run through, I would like to add a string afterwards. I would have thought I could just add an append line event under appand range. However, the Excel file then crashes. How do I get it to write a string under append range in my Excel file during the loop? … See Pictures

Thank you for help…:slight_smile:

Hi @Maxi_B,

Two options,

  1. Create a temporary datatable with 1 column, add the string value to the datatable(first row, first column) then use append range also.

  2. If you want to update specific cell for some string value, use the write cell activity.

how can i create a datatable with 1 column?

@Maxi_B

Check below for your reference
https://forum.uipath.com/t/tutorial-how-to-calculate-difference-between-two-time-values-using-uipath/247565/3

Hope this helps you

Thanks

Use build table activity and define the table schema