How to calculate data of different columns and keep the unqualified ones in another excel sheet

[Sachin_Desai]

You can use the datatable.Select(Decimal.Parse(Column6) = (Decimal.Parse(Column1) + Decimal.Parse(Column2) - Decimal.Parse(Column3)).CopyToDatatable(). This will give a datatable with all the qualified rows and if you use not equal to instead of equal to it will give you not qualified rows.
Refer to this post, which says something similar:-

Copy dataTable row to another dataTable

Hi! I have tried to figure this out for a week now. So my problem is i have one big excel file with 12 columns in one row and it has lot of rows. Now i want to divide it to different excel files depending on one column. I have figured out how to get the specific row but now i need to add the rows to the new datatable that i can create the file. How to do that? Now i have done it so that i go through for each row in the datatable and inside the loop i use get row item then i use add data ro…