How to set Filter line to visible


#1

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

#2

Can u please attache any sample file

Regards
JothyPrasanth M


#3

Book2.xlsx (8.8 KB)


#4

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

Regards
JothyPrasanth M