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

Help Studio
#1

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:

hilfe1
hilfe1669×686 29.5 KB
Hilfe2
Hilfe2929×604 24.9 KB

#2

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.

#3

how can i create a datatable with 1 column?

#4

@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

#5

Use build table activity and define the table schema