We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Controlling filter status of table header

Hi,

Using latest 17.02 Aspose Cells release for Java.

I'm trying to reproduce the following sequence of operations in Excel through the Aspose Cells API.
1) On a sheet, I enter the following data in cells A1:B3

col1 col2
1 2
3 4

2) Using menu Insert->Table, using option "My table has headers", I create an Excel table

3) Using menu option Data->Filter, I disable the display of the filter dropdowns in the newly created table

It is clear how to perform steps 1 and 2. However, how do I the equivalent of step 3 though the Aspose Cells API?
See the attached file created in Excel, with filter dropdowns disabled for the Excel table in Sheet1.

Thanks in advance,
Taras

I found the answer in another post on this forum:

Disable AutoFilter while formatting a list object (table)

Hi Taras,


It is good to know that you have found the solution. Please feel free to contact us back in case you need our further assistance with Aspose APIs.