How to replace the Excel sheet(rows and columns) data with new data

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.


Just delete the file and Write Range to a new file.