Delete empty row

[pravin_bindage]

I’m removing maching value from data table after that i want to rewrite that table to same excel file ,but it was not removing complete row from data table some columns have sum at bottom these corresponding column rows not removing? anuyone know why ?

[Anil_G (Anil Gorthi)]

@pravin_bindage

Did you try using filter datatable to filter out the non required rows?

cheers

[supermanPunch (Arpan)]

@pravin_bindage

i want to rewrite that table to same excel file

Hi @pravin_bindage ,

When rewriting the data to the same excel sheet, you would need to remove/Delete the rows that is already present and then Insert the new Data.

The removal of existing data can be done by using a Write Cell Activity. Below post describes the steps to perform the operation :

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…