JeffreDodd JeffreDodd - 1 year ago 222
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

Answer Source

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";
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download