I have an excel with multiple colum .I am trying to filter column as “Ccy=EUR”
I am using the datatable and select to filter
But I am getting this error
I have an excel with multiple colum .I am trying to filter column as “Ccy=EUR”
I am using the datatable and select to filter
But I am getting this error
Hi,
Could you please check the add header property of read range.
Hey @sampaddas
If you have already checked headers property which i assumed you have because @ddpadil here Column Name should come in the left of assignment operator not in the right
@sampaddas try this and let me know dtTable.Select(“[CCy]=‘EUR’”)
Regards…!!
Aksh
Thanks aksh ! It worked!
One quick question - Is there a way by which we can get the filtered data along with the ‘Header’ ?
well you can
For your Ref. -
Regards…!!
Aksh
Thanks !