JeffreDodd JeffreDodd - 5 months ago 30
C# Question

Aspose.Cells for .NET Enable Data Filtering

I just started working with the

's library for .NET and am having some issues finding documentation on how to enable Data Filtering for an output Excel sheet.

I understand this functionality is built into
and documented here ( however I cannot use this namespace to produce a document with this filtering enabled.

Is this functionality just not possible through the use of


Aspose provides this functionality through the Aspose.Cells.AutoFilter object.

The documentation can be found here:

And an example can be found here:

To add autofilter to a heading row:

//Creating AutoFilter by giving the cells range of the heading row
worksheet.AutoFilter.Range = "A1:B1";