Filter DataTable issue to write in text file

Help
,
1

hi,
i have excel file and columns like–> Model,Color, price
if price is >500 i want to write in text file.
i tried but it showing error …
can anybody help…
…Pendrive.xlsx (11.4 KB)

2

Hi @Anand_Designer,

What do you want to write in text file?
What’s the error you are facing?

Cheers
@Anand_Designer

3

i want to write data where price >500 write to text file all columns.
i used read range > for each row > for each >if> write text file
i am getting error like below

image
image1366×768 97.4 KB

4

Okay Do this,

Use For each row, If Cint(row(“Price”).ToString.Split("₹"C)(1))>500 then write to text file.

Dont use For each

Cheers

5

Also note that you are using a for each on item as DataRow but your if you are using row

You have to change your condition in the following
Double.Parse(item.Item(2).ToStiring)>500

6

@Pradeep_Shiv
i followed your code, but it shows error in append line

image
image1366×768 104 KB

7

You have to write a variable of type string inside the Input field in Append Line.
So for example change row to row(“Price”).ToString in order to write the price into the file

8

Thanks for given solution @Pradeep_Shiv @stefano_negro,

9

Good
Happy learning!
@Anand_Designer