Facing difficulty in clearing the excel sheet data

Learning Initatives Automation Starter
, ,
1

Hi,

Here data scrapping is being performed. From the data scrapping data i need to fetch the filename. For that I am using the excel sheet to write the data, problem here is the overwriting not clearing the sheet.
Only for 1st iteration its clearing for rest its over writing. Not able to use clear data table getting error as object not set to instance of object. So i used write cell
image
Its working only for 1st iteration and same data over writing.
I used invoke vba also same issue. Can any one help me on this.

Regards,
Lakshmi

2

Hello @lakshmi.mp ,

Perhaps you could try the Clear Sheet/Range/Table activity.

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

Best regards,
Marius

1 Like
3

Hello @lakshmi.mp

Are you trying to write the datatable to excel?

Then you have to use Write Range activity. It will clear the existing data and replace with the new data.

Thanks

4

@Rahul_Unnikrishnan , yes
But over writing.

5

image
Range should be blank. I will try this.

6

can you please share a screenshot of the workflow?

Else you delete the sheet using Delete sheet activity and then use Write Range to create the sheet again.

Thanks

7

@Rahul_Unnikrishnan

image
image1291Ă—526 45.1 KB

Getting this error. What to do.

Regards,
Lakshmi

8

Is this Write Range activity inside an excel scope and is this Data_Extract having some value?

Thanks

9

Yes its inside excel app scope and has some values.

10

image
image575Ă—708 16.9 KB

image
image1348Ă—673 57.6 KB

image
image688Ă—674 15.8 KB

Please look on it.
Regards,
Lakshmi

11

image
Try like this in Range use " "

12

@prithivi_raj_shanmugam

image
image1251Ă—276 16.5 KB

Getting error.

13

Can you share the datable value in debug mode? If datable is empty “Write range: object reference” error will come. Run in debug mode and view the output of extract structed data variable “Data_extract”.

image

14

@lakshmi.mp in Range use “” without space, by mistake I gave with space. Try without space it will work

image

15

@prithivi_raj_shanmugam @Rahul_Unnikrishnan @Marius_Puscasu , thanks for helping.
Again i did data scrapping for that particular screen and now able to clear the excel data using clear data table activity, and mentioned value in default. New System.Data.DataTable
Issue resolved.

Thanks,
Lakshmi

1 Like
16

good to hear that @lakshmi.mp

1 Like