How to filter 0 and Blanks columns in excel and delete filtered columns from the input file using uipath linq query

Help Activities
, , ,
1

Hi Team,
i have one excel with bulk data. i need to filter 0 and blank rows in Column W. After filtering the rows need to delete those filtered data from the same excel file.

2

Hi @Ramudu

Use Filter DataTable activity

The image depicts a "Filter Wizard" interface used to filter rows in a data table by removing rows where a specific column value is either zero or empty. (Captioned by AI)
The image depicts a "Filter Wizard" interface used to filter rows in a data table by removing rows where a specific column value is either zero or empty. (Captioned by AI)770×497 20.3 KB

Regards,

3

Hi @Ramudu

Please try the below linq

(From row In dt.AsEnumerable()
Let v = row(“ColumnName”).ToString.trim
Where Not v.Equals(“”) AndAlso Not v.Equals(“0”)
Select row).CopyToDataTable()

4

After filtering the data need to delete those data from the current excel file using linq quires

5

Pass the output of linq query to write range activity it will update the excel sheet.