Free Support Forum - aspose.com

Backgroundcolor pivottable

Dear Aspose,

How to set a backgroundcolor in a pivottable?

Outside the pivot table is no problem, but it's not working in the pivottable.

Martijn

Hi,

Well, currently, you may 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 implement your desired feature in Q1 2010.


Thanks for your understanding!