Free Support Forum - aspose.com

Customize a PivotTable

Hi everybody,

It makes 1 week that I study Aspose.Cells. I would like to know if there is a way to customize the styles of the Pivot Tables.
Actually, there is an enum called “PivotTableAutoFormatType” than contains some styles but they don’t correspond to my needs.

Thanks a lot !

Hi,

Well, I am afraid, currently, you may only try some auto formatting options for the pivot table using the AutoFormatType enum in the API, e.g
pivotTable.AutoFormatType = PivotTableAutoFormatType.Report6;

And, we are working on reading pivot tables in the template files, we will try to support the feature before the end of Q3 2010.

We have already logged the feature into our issue tracking system with an issue id: CELLSNET-4661.

Thanks for your understanding!