Is there a way to filter datatable based on column names and not the column values.
If i am using select query to filter there I need to give some column values but I want to filter using column names.
I will have an excel sheet generated in every run, I will be having an array of predefined column names, say (, Test01, Test02, Test03…Testn). I will have to check in every excel sheet whether they have any of the column names between Test01 -Test0n.
Every sheet can have any number of column names from the predefined list.
So, if the excel sheet contains column names as Test01 and test02, so I need to filter the sheet containing only those 2 column names.
Any suggestion will be very helpful.