I’m reading numbers from excel and I want to write again numbers which are even. I’m trying filter them with mod 2 function in if statement but not having success. Instead it writes same numbers again without filtering out the odd numbers. Any help to this? [image]

Fine hope these steps would help you resolve this, –use a excel applicatiion scope and pass the file path as input –inside the scope use READ RANGE activity and get the output with a variable of ttype datatable named dt –now use a assign activiity like thiss dt = dt.Asenumerable().Where(Functio…

Writing even numbers to excel file which are read from data table

Help

sarathi125 (Parthasarathi) October 29, 2019, 10:50am 5

FilterData.xaml (4.9 KB)

Check this xaml, I have filtered some excel from my desktop.

1 Like

Remove odd numbers of Data table and show the new Data table with only even numbers

Topic		Replies	Views
How to extract odd and even numbers from excel sheet and write it new excel sheet Studio studio , question , activities_panel	6	1306	July 8, 2021
Remove odd numbers of Data table and show the new Data table with only even numbers Help studio	18	3784	November 2, 2019
Problem with data table which mod's odd numbers out Help	5	1528	October 29, 2019
Remove odd numbers from the excel Help	17	2150	July 2, 2019
Filtering the datatable based on two or more condition Help studio	7	2771	November 15, 2018

Most Active Users - Yesterday
Anil_G
jast1631
donghai
gulsheen_kaur1
More details...

Writing even numbers to excel file which are read from data table

Related topics