I have a sheet in Excel, where I am storing scraped data which consists of multiple rows and columns, I want to replace that whole data with the new scraped data.
Note: No.of columns will remain same every time but rows may vary
I have a sheet in Excel, where I am storing scraped data which consists of multiple rows and columns, I want to replace that whole data with the new scraped data.
Note: No.of columns will remain same every time but rows may vary
Hi Good to see back
see one thing if columns are also same then with the help of
Write Range activity
The values will be replaced with the new values.
cheers
Just delete the file and Write Range to a new file.