How can i delete a row from an excel ? Is there any activity outside excel application scope

[supermanPunch (Arpan)]

@ASWATHY_K

i used “delete/insert row” activity with inside the excel application scope .I want the activity can use outside the excel application scope

Hi @ASWATHY_K ,

Alternately, using the Datatable methods, We should be able to delete the row from the Excel, But provided we would require to clear the sheet and update the Sheet with the Filtered values from the Datatable.

You could try following the below steps :

1. Read the Excel sheet as a Datatable, say DT.
2. Filter the Datatable, so that you keep only the rows which are Required, and the result is stored in FilteredDT.
3. Next, You can use Write Cell Activity to delete all the rows present in the Excel sheet. With Range as "A1:E"+(DT.Rows.Count+1).ToString and value as "" (Empty String) .
4. Next, Use Write Range Activity and write the FilteredDT to the same sheet.

For cases, where you do not know the Last Column Name, you could refer this post, as the below post also describes on clearing the Sheet without Excel installed.

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…