I want to clear sheet without excel in my machine

[Shubham_Bidwai]

hello connecion ,
i want to use clear sheet but i dont have excel in my machine

[Gokul001 (Gokul Balaji)]

Hi @Shubham_Bidwai

1. Clear Range - This activity allows you to clear the data from a specified sheet, range, or table. You can use it with an Excel file selected for a parent

2. You can also try with Invoke VBA activity - This method allows you to execute custom VBA code to clear an excel sheet using macros.

dim ws as worksheet
Set ws = Sheets ("Sheet1")
ws.Cells.Clear

Regards
Gokul

[Shubham_Bidwai]

in that way excell need to install or not and where to add the expression

[Gokul001 (Gokul Balaji)]

Hi @Shubham_Bidwai

You need to install the MS Excel in your PC. And you this below expression in the Invoke VBA activity

@Gokul001

dim ws as worksheet
Set ws = Sheets ("Sheet1")
ws.Cells.Clear

[supermanPunch (Arpan)]

Hi @Shubham_Bidwai ,

Could you Check the below post :

Delete Excel data range without Excel Installed

@kasey.betts , Assuming that we have the Data already available in Datatable, which Represents the Data in the Excel, we can use it’s Column Count and Row Count information to Clear the Contents using Write Cell Activity. For Example : Let the Datatable be DT We get the Column Letter of the Excel by using the Column Count information as follows : columnLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.Count+1) The above would help us get the Col…

Maybe using workbook activities also we will be able to achieve your required output.

Let us know if this post was not helpful.

[Anil_G]

@Shubham_Bidwai

You can use workbook write range with empty data and uncheck headers option so that all the data from excel will be removed

cheers

[Shubham_Bidwai]

after adding empty data table shows error @Anil_G

[Anil_G]

@Shubham_Bidwai

You have to initialize the datatable …use a build datatable and just add one column…dont add any data…

Cheers

[Shubham_Bidwai]

it was only remove one row after built data table @Anil_G

[Anil_G]

@Shubham_Bidwai

Yes this how you have to do…Makesure you remove one blank row as well

Or you can have it like that and run it…Ideally it should clear

cheers

[Shubham_Bidwai]

okay thank you @Anil_G