For instance, I would like to delete rows where cell “Amount”= 0 or “Amount”= Empty, from Sheet1: Input: [image] Output Expected: [image] I tried using the method below but the filtered rows never were deleted… [image] Note: I cannot use unofficial activities Regards,

@Tana20 - Here you go… [image] LINQ Query in the Assign activity dtInput.AsEnumerable().Where(Function(row) Not(row(“Z”).ToString.Trim.Contains(“0”) or row(“Z”) Is DBNull.Value Or row(“Z”).Equals(“”) )).CopyToDataTable Input [image] Output [image]

How to delete rows in the same sheet (Excel)?

Help

prasath17 (Guru) November 18, 2020, 2:34am 5

@Tana20 - Also check the post below

Topic		Replies	Views
Delete row Activities excel , activities , question	5	626	April 18, 2022
How can i delete rows that can be empty or not Forum question	6	1214	March 12, 2021
Delete row in excel in value in column = 0 Activities excel , activities , question	14	1437	February 9, 2022
Delete empty row Activities excel , activities , question	3	481	December 14, 2022
How can I delete all rows in an Excel with a certain value? Help	7	2191	May 27, 2019

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

How to delete rows in the same sheet (Excel)?

Related Topics