Delete empty rows in excel

[supermanPunch (Arpan)]

@Aregala_Yedukondalu

but i need in sheet 1 only

@Aregala_Yedukondalu ,

If that is the case, then we can perform a Clear Data operation using Write Cell Activity first on the Sheet, then you can use Write Range Activity on the Same sheet.

If you have access to Modern Excel Activities, then you could try with the below Approach as well using Clear Sheet/Range/Table Activity.

If modern activities are not preferred, then you could check with the below post on using Write Cell Activity to Clear the Sheet.

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…