Delete all rows from excel

hi Guys,

i am having one excel template , where i am inserting data to it then copying it to another folder, so every time values are changing so correct data insertion is not happening as old data is still there in template, so i was thinking to delete all rows from template every time.

How to cater this, please help

@amruta_pawar instead of deleting all rows, why don’t you create a copy of the template and update the data there instead of updating in template

3 Likes

@amruta_pawar I would suggest you to have the template file at shared location or a common repository.
Whenever you do excel manipulation, copy it to the working directory and start appending to it.

2 Likes

ok let me try by this way

ok will try this

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.