How can I get source for PivotTable

Hi,

My workbook has the connected another workbook. I created the pivot table from that connection. When I try to get source from my pivot table (pivotTable.GetSource()), it returns NULL. How can I get source for pivot tables with external source?

I’ve attached sample document and demo project, that displays values of all properties in PivotTable object.

Thank you,
Alex Shloma

Hi Alex,


I am afraid, we do not support to get external data source for a Pivot Table at the moment. I have logged a ticket for it with an id: CELLSNET-40034.
We will look into it later.

Thank you.

Thank you!

@licenses
We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells for .NET 24.11) that we plan to release in the first half of November 2024. You will be notified when the next version is released.

The issues you have found earlier (filed as CELLSNET-40034) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi