How to overwrite the file for every time run the robot

Help Activities
, ,
1

Hello guys,

I wrote the robot for extracting data to the destination file. However, I realized that it wouldn’t overwrite the existing data in the Excel file. How can I specify in the robot to overwrite the file every time? Thanks for help !!!
T2_Finalise_1.1.xaml (37.2 KB)

2

@CHAN_Hiu_Fung_Victor_Stud

If you are using same sheet then write range should over write the file

If not just delete the file at the end of execution so that same is created again when it runs again

Cheers

3

Hi @CHAN_Hiu_Fung_Victor_Stud

Use Delete File activity before Write Range Workbook as Write Range Workbook will create a file during runtime. So the extracted data is written to excel.

Hope you understand!!

1 Like
4

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