Rows need to delete for specific rows need to keep

[supermanPunch (Arpan)]

Hi @chaitanyaKumar ,

Assuming you have read the Excel sheet data as a Datatable, then we could use the below expression :

UpdateDT = DT.AsEnumerable.Take(10).CopyToDatatable

Then, you would require to write the output in a new Excel sheet.

To Write it in the same sheet, you could clear the Sheet contents using Clear Range activity (Modern) or could follow the approach here :

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…