Posted 8 July 2020, 9:24 am ESTI would like to add an automatic filter on a generated file where the first row is the header and the rest is data.
This seems to be supported but when I try this:
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.Worksheets;
worksheet.AutoFilterMode = true;
I get this exception:
System.NotSupportedException: Can't set the value to true.
at at GrapeCity.Documents.Excel.Worksheet.set_AutoFilterMode(Boolean value)
How can I accomplish this?
I do not want to apply filters I just want the autofilter dropdowns to be there when I open the file...