Pivot table style options

Aspose.Cells Product Family
1

hi

we are using aspose cells 2.5.4.17.

we have to do some enhancement to pivot table.

how to set Banded rows and Banded columns for pivot table.

please find the attached image

Thanks & Regards

eistechnologies.

2

Hi,


Please try our latest version v7.0.0, we have supported to set/get PivotTable’s built-in Styles. You may use setPivotTableStyleType() and setPivotTableStyleName() methods for your requirement.

Thank you.
3

hi

by using PivotTable.setPivotTableStyleType/setPivotTableStyleName() methods how to set those pivot table style features.

we found that pivot table has some methods for pivot table style features like rowheaders columnheaders.

setShowPivotStyleRowHeader(boolean value)

setShowPivotStyleColumnHeader(boolean value)

we are looking these type of methods for banded row and columns.

Thanks & Regards

Eistechnologies.


4

Hi,



We think you may use the following methods for your requirement:

setShowPivotStyleRowStripes(boolean
value)

setShowPivotStyleColumnStripes(boolean value)


Thanks.