- I am getting data from several webpages.
- For each page, I am getting a list of data, say pdffile names
- I save the list into the datatable within each loop
- In the end I want to save all of them into a excel file
Ideally I thought the 2nd loop would save from the row under the last row of the current sheet, but it overwrote from cell A2. If I use append… it went to hundreds of repeated records…
I attach my xaml here, can anyone help please? Thanks.
test.zip (49.7 KB)
I checked the solution in an old post, but it used counter =counter +1 , I don’t know how to modify into my for each activity …
Write range overrides and gives the latest file processed data. how to get rid of this overridden thing?