Pivot Table data model and relations

Aspose.Cells Product Family
1

In Excel I can create a Pivot Table and use a table as the Data model. I can then create relationships between tables using primary and foreign key relations between the tables. Is this functionality available with Aspose Cells.


2

Hi,


Thank for your query.

Well, Aspose.Cells does support to create or manipulate PivotTables, see the documents in the section for your reference:


Regarding create relationship b/w the Pivot Tables, Could you provide us a sample file (you may create your file in MS Excel manually) which contains Pivot Tables with established relationship b/w the tables. Also provide the steps details on how to accomplish the task manually in MS Excel, we will check it and may log ticket for it (if possible) to support it.

Thank you.