Combining workbooks with pivot tables change the pivot table's source from a table's name to a cell range

Aspose.Cells Product Family
1

I’m using Aspose Cells 8.5.1 for .NET

I have the following source code:

Workbook workbook = new Workbook(".\test1.xlsx");
Workbook workbook2 = new Workbook(".\test2.xlsx");

workbook.Combine(workbook2);

workbook.Save(“output.xlsx”);

I
attached the files test1.xlsx which it doesn’t have any content and
test2.xlsx which contains a table and a pivot tables in different
sheets. Pivot table’s source is the table’s name but after combining the workbooks the pivot table’s source is defined as the cell range of that table. Then if I add some rows to the source table the pivot table never realizes about them because it is pointed to a specific cell range.

2

Hi,

Thanks for your posting and using Aspose.Cells.

We have tested your issue with your sample code and sample excel files using the latest version:
Aspose.Cells for .NET (Latest Version) and found it is working fine.

I have attached the output excel file generated with the latest version for your reference. Please download it and try at your end and let us know your feedback.

3

Yes, It’s true it is working fine with Aspose.Cells for .NET v8.8.0.1. I will update to the latest version. Thanks Shakeel.

Andres

4

Hi,


Good to know that the latest version/fix figures out your issue. Feel free to contact us any time if you need further help or have some other issue or queries, we will happy to assist you soon.

Thank you.