How to delete content from existing excel sheet

Help Studio
, ,
1

hi friends, I am using a write range to write into an existing excel sheet but i noticed it doesnt clear the excel sheet before writing into it. For example i have 10 rows filled with data, and the bot writes into it three new data and only overwrites three of the rows and not the rest. how can i clear the excel sheet before it writes into it? please provide workflow if possible. i do not want to delete the the excel sheet just clear it.

2

Just write to a new file, then delete the old file.

3

@Shazid_Rahman

Check below link for your reference

Hope this may help you

Thanks

4

i dont want to delete the file

5

Hey @Shazid_Rahman !! Use write cell activity then pass blank value to range “A1:Z50000”

Hope it helps!

6

could you show workflow please and please keep in mind header must not be deleted

7

To not delete Headers, pass the range “A2:Z50000”

image
image1241×663 16.7 KB

1 Like
8

Hi @Shazid_Rahman,

Try this method.

  1. Read the excel file using read range activity [FirstDT]
  2. Use Assign activity
    SecondDT = FirstDT.Clone
  3. Add the values in the SecondDT datatable which holds the value with all new values only and the headers will remain the same.

Hope this would help to solve your issue.

Regards,
@90s_Developer

9

You are writing a new file with the data the way you want it, and deleting the old file. This is literally no different than editing the existing file.

10

The workbook Write Range would be better, it doesn’t have to open the Excel file. Faster and more reliable.

11

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