How to clear Excel Sheet using Uipath

[Hey_hi]

Hi Everyone,

I would like to ask how can I clear my excel sheet data using write range? without using the method of VBA.

Hope anyone can help me

[ushu (Usha kiranmai)]

Hello @Hey_hi You can use Delete Range to clear the excel sheet data. Refer attached workflow

Example.zip (10.1 KB)

[Hey_hi]

Hi @ushu , I have tried running your problem and it seems there is an error

[ushu (Usha kiranmai)]

@Hey_hi Can you share you excel sheet screenshot

[ushu (Usha kiranmai)]

@Hey_hi Please try changing the range within the delete range activity

Ex: if your excel has A:G columns then change that accordingly in the code

[Hey_hi]

@ushu

[ushu (Usha kiranmai)]

@Hey_hi For Read Range did you enable headers.If so, then disable and try it

[Gangadhar_Athili]

Or Else
Write Cell Activity
Range : “A1:F”+(DT.RowCount+1).Tostring
Value : “”

[Gokul001 (Gokul Balaji)]

Hi @Hey_hi

Have a look on it

Delete all content in an Excel Sheet

Hello Friends, how is it possible to clear all the content inside an Excel Sheet? I tried with send hotkeys but it didn’t work. How is it possible to delete all the content in this sheet? Movimenti.xlsx (9.5 KB) Thank you so much friends, Camilla.

Multiple way to Delete Excel Sheet in UiPath | Delete multiple Excel sheets in UiPath RPA

Regards
Gokul

[raja_ias (PALANIRAJA PARAMAN)]

Use Build data table make sure no value should be there. Then use writerange activity uncheck headers if you don’t want.

[lakshmi.mp]

Hi,

Use clear data table activity and pass the datatable name.

Thanks,
Lakshmi