Remove row from excel sheet

Help Forum
,
8

hello @sshitol ,

See Below Output is expected output

The image shows a UiPath workflow for reading an Excel range, converting the data table to an enumerable, and logging a message, with the Immediate panel displaying the contents of the "dt_Input" variable before and after conversion. (Captioned by AI)
The image shows a UiPath workflow for reading an Excel range, converting the data table to an enumerable, and logging a message, with the Immediate panel displaying the contents of the "dt_Input" variable before and after conversion. (Captioned by AI)970×546 48.2 KB

dt_Input.AsEnumerable().Where(Function(row)  row.Field(Of Double)("Weight") <> 0 AndAlso  Not (row.Field(Of String)("Ticker").Count(Function(c) c = "$"c) > 1 OrElse  (row.Field(Of String)("Ticker").Length = 5 AndAlso row.Field(Of String)("Ticker").EndsWith("XX")))).CopyToDataTable

Main.xaml (8.2 KB)

Regards
Dheerandra Vishwakarma

1 Like