How to set Filter line to visible

Hello,

How to set a line as a Filter using a datatable;  i can use hotkey (Ctrl + Shift + L) on the Excel but i need to do it on a datatable

Can u please attache any sample file

Regards
JothyPrasanth M

Book2.xlsx (8.8 KB)

For filter the datatable you can use Select Method
Syntax: Datatable = filterDatatable.Select("[ColumName]= ‘Value_to_Filter’ ").CopyToDataTable

Regards
JothyPrasanth M

1 Like