Hi all, I have one excel file in that excel i have one column name length if the length <150 I want to delete that particular rows. Could you please help to solve that problem. [Capture5]

[image] Lakshay_Verma: dt=(from dr as datarow in dt where cint(dr.item("Length").tostring)>150 select dr).copytodatatable can you solve this error [delete]

@Buvaneshwaran_R You can achieve this by below code dt=(from dr as datarow in dt where cint(dr.item("Length").tostring)>150 select dr).copytodatatable

[image] Lakshay_Verma: dt=(from dr as datarow in dt where cint(dr.item("Length").tostring)>150 select dr).copytodatatable where i want to give this condition assign or if condition

@Buvaneshwaran_R Use this in assign, It will give you datatable with rows that have length more then 150

@Buvaneshwaran_R Hey, Let me explain you this. Once you read this excel file and output the data in datatable. Using above code, it will give you output as datatable without rows that have length less then 150. so you won’t get deleted rows rather you get all rows that have length more then 150 …

Delete Particular rows in excel using if condition

Learning Hub Academy Feedback

Pankaj.Patil (Robot Master) July 3, 2020, 8:05am 7

@Buvaneshwaran_R

you could use Filter Datatable activity.

Delete Rows

blue icon appears because i did not create varible, you will have to supply datatable.

Cheers,
Pankaj

Topic		Replies	Views
Delete row in excel? Activities excel , activities , question	7	160	June 20, 2024
Filter Datatable based on length Help	10	4545	June 6, 2019
Filter remove lenght Studio datatable , activities , question	8	1293	May 3, 2021
Remove a datarow based on a specific criteria Studio	4	143	February 27, 2024
Delete data rows based on column values Learning Hub datatable , excel	7	958	May 29, 2020

Delete Particular rows in excel using if condition

Related topics