Filter Excel Table using specific conditions

Hi All,

I’ve this Excel file on which I’ve to apply specific conditions and filtered it out.

Input Looks like this: (below Image)

image

Conditions:

  1. If the “Name of the person” column has characters greater than 40 there should be “Abbreviation”.
  2. If the “Name of the person” column has less than 40 characters than it is not compulsory to have the “Abbreviation”.
  3. The “Address” field is compulsory.

Output Looks like this: (below Image)

image

Greater than 10*

@Abhishek_Changan
in such scenario the dynamic generation of a filterexpression used in the datatable.Select Method is an approach to implement this task:


https://www.csharp-examples.net/dataview-rowfilter/
1 Like

Hey @ppr

I got the answer.

Thanks for helping me out

@Abhishek_Changan
Perfect. So once it is running just close the topic by marking the solving post as solution. Let us know your further questions if there are any open items.

1 Like

Hy @Abhishek_Changan,

Find attached the solution for your taks.

FilterExcelCondition_Test.zip (30.8 KB)

If it is ok for you please dont forget to like and mark my answer as a solution for your post.

Thanks

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.