I have use case where I want to write data scrapped from a website to excel.
Scrapping happens for every transaction and corresponding data I need to add to excel.
My current approach is to
- get data
- create a data table
- add data to table by using add Data row.
- use append range to write it to excel
Problem is as it happens in every transaction new data table with only the new raw is getting created each time and when append is used last data is getting overwritten with the new data table values.
Is there any alternative approach to use append range without overwriting the existing exceldata.