Delete Sheet Item

[vrdabberu (Varunraj Dabberu)]

@Shivam_Rana

Please try the below sequence and you can delete all the rows with your required condition.

Please use this syntax in value to save (From row In dt1.AsEnumerable() Where Not (row.Field(Of String)("Column1") = "No") Select row).CopyToDataTable()

Here Column1 is your column name and dt1 is your datatable variable.

Sample Input:

Sample Output:

Regards

[postwick (Paul Ostwick)]

Read Range into a datatable
Filter Data Table to remove the rows you want
Write Range to a new Excel file

[supermanPunch (Arpan)]

@Shivam_Rana

Additionaly Can we delete the whole sheet 1 data?

Hi @Shivam_Rana ,

An Alternative on deleting the Whole Data present in the sheet, you could check the 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…

[vrdabberu (Varunraj Dabberu)]

@Shivam_Rana

If you find the solution for your query please do mark as solution to close the loop

Happy Automation!!