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

Free Support Forum - aspose.com

How to add pivotItem to pivotItems and pivotItems to pivotfield

Hi Aspose,

1) We are using a pivoted excel template which has empty pivoted Items. We want to dynamically add pivoted items. Can we do this using Aspose Cells Java?

2) We created pivoted sheet using Aspose which looks good. Is it possible to reorder the Pivoted Item, we need this because we want a pivoted item to be always last item in the matched filter.

Example :- In the attached file look at the CLOSED POSITIONS column to be always last in the filter(I marked in the green color)



Hi Raj,

Thanks for providing us the template file.

Well, I am afraid all types of manipulation to an existing pivot table is not supported. We may consider this feature and support it in the future versions.

Thank you.


I think you may use "PivotField.setAutoSort(true);PivotField.setAscendSort(false);" for the "Strategy" field.