How to clear excel sheet

Help Studio
1

Hello,

I’m downloading files from website by using table extraction i selected file and url using Table extraction and that all data save in Excel file so

Whenever I’m running the process so each time new record will buy some some time no record is there but the which data available in Excel sheet getting only that file i don’t want to again n again same file

How to clear excel sheet again again?

2

@suraj_gaikwad

  1. Use a timestamp to save the file so that the filename would be different always…something like this "Extract" + Now.ToString("MMddyyyyHHmmss") + ".xlsx"
  2. You can as well delete the previous file and recreate new
  3. Use clear sheet activity with range or sheet as Excel.Sheet("Sheetname")

https://docs.uipath.com/activities/docs/clear-range-x

Hope this helps

Cheers

3

Hi @suraj_gaikwad

If you are using Excel activities “Use Clear Sheet/Range/Table” activity to clear the sheet. Activities will be Excel Process scope → Use Excel File → Use Clear Sheet/Range/Table

image
image616×686 21.4 KB

If you are using workbook activities at initial process please read the entire excel using “Read Range Workbook” activity and store it an datatable. then use “Clear Data Table” activity to clear the data in the particular sheet.
image

Hope it helps!!
Regards,

5

IMG20230529105117
IMG202305291051171800×4000 855 KB

IMG20230529105432
IMG202305291054321800×4000 341 KB

6

@suraj_gaikwad

Before the Write range…use any of the acitivities specified above

cheers

7

But which should I use bc i try to use clear data table den I’m passing Excel file path

8

IMG20230529110830
IMG202305291108301920×864 66.4 KB

9

@suraj_gaikwad

Clear datatable will not work…

use clear sheet

or

Delete file

Or

Use a different filename always

Clear datatablew ill only clear the datatable you are writing but not the excel

cheers

1 Like
10

Use different file name i didn’t get

11

@suraj_gaikwad

Whenever you write to excel if you want to preserve the previous excel as well then instead of writing to same excel always we can make it dynamic by adding timestamp as I have depicted above

cheers

1 Like
12

Okay !

Thanks

13

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