Controlling filter status of table header

Aspose.Cells Product Family
1
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
2

I found the answer in another post on this forum:

Disable AutoFilter while formatting a list object (table)

3

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.