Free Support Forum -

Button to filter columns

I create a report that has a bunch of columns. I would like to add a button into Cell A1 that allows me to select the column header(s) I want to see and hides the other columns. Is there any way to do that in Aspose.Cells?


I think you might be talking about Auto-Filters feature, Aspose.Cells for .NET does support it, see the document:

If you need to hide / show whole columns simply, see the document:

Also, for your information, we don’t support vbas/macros, so you cannot do event handling to perform specific features although you may simply add Command buttons if you want:

Thank you.