Is it possible to extract the custom pivot style out?

Aspose.Cells Product Family
1

Hi,

Our client has created a custom style in one of their work book called "board paper". And they want to apply this style to all of their workbooks in our solutions.

Is it possible to extract the custom pivot style from the workbook and apply to other pivot tables?

I have attached the workbook for you investigation.

Regards

Bill

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

I have forwarded your question to our development team and logged it in our database.

We will look into it and provide you a sample code asap.

This issue has been logged as CELLSNET-40331

3

Hi,

After looking into this issue, we found it is a New Feature.

We will implement it in near future if it is is possible.

4

Thanks Shakeel! Much appreciated.

I understand this is a hard feature, but look forward to hear the good news from you guys:) However, if it doesn't seemed possible, please let us know so we can manage the expection of our clients.

Regards

Bill

5

Hi,

We have fixed this issue. Please download: Aspose.Cells for .NET v7.1.0.5



Please use the method of pivot table named “copystyle” in the latest aspose version 7.1.0.5.


C#


Workbook wb = new Workbook(“svxBoardPaper.xlsm”);

Workbook wb1 = new Workbook(“input.xlsx”);

wb1.Worksheets[0].PivotTables[0].CopyStyle(wb.Worksheets[0].PivotTables[0]);

wb1.Save(“out.xlsx”);



6

Hi,

I have verify that the new dll fixed our issue. Thanks again for the excellent support work! Much appreciated.

Regards

Bill

7

The issues you have found earlier (filed as CELLSNET-40331) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.