How to delete entire row in excel if the specific column is empty

[supermanPunch (Arpan)]

@Nur.ain

Do you have any way to do in the same Sheet?

Hi @Nur.ain ,

For Writing to the Same sheet or overwrite the data existing, sometimes the data to be written is lesser than the ones present in the Excel sheet. In these cases, we would require to clear the sheet contents at first and then write the Data to the sheet.

For this one of the methods is mentioned below :

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…

We could also create empty rows and add/append the empty rows to the Datatable according to the total rows present in the Existing sheet and then write the datatable to the same sheet. Topics related to creating empty rows :

Creating Empty Datatable

We have understood so far An existing Worksheet is to update the new data is less and old rows are not deleted When the idea is about creating a datatable with empty values and rows count of old data give a try at the following Read range - dtOld Assign Activity: dtCleaner = Enumerable.Repeat(dtOld.NewRow, dtOld.Rows.Count).CopyToDataTable