I have a loop process to scrape data from a web and paste it into Excel and it looks like this.
Each data in red box got extracted from the loop process.
However, I need to write value inside the highlighted cell in green - which is in between of the extracted data. The number of rows in each extracted data is dynamic so I can’t set a specific cell to write the value.
The value is Day 1, Day 2 and so on respectively until the last day of the month.
I have tried Write Cell and Write Range activity but it keeps got overwritten by the extracted data.
If you choose to use Invoke Activity then you have to read carefully the error message. For example , the issue “Expression is of type “System.Data.DataTable”, which is not a collection type. At line 1” can be solved using “For each row in ExtractDataTable.Rows”