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	1327	July 8, 2021
Remove odd numbers of Data table and show the new Data table with only even numbers Help studio	18	3802	November 2, 2019
Problem with data table which mod's odd numbers out Help	5	1533	October 29, 2019
Remove odd numbers from the excel Help	17	2162	July 2, 2019
Filtering the datatable based on two or more condition Help studio	7	2773	November 15, 2018

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

Related topics