How to create Excel data model relationships using Apache POI?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

How to create Excel data model relationships using Apache POI?

Piotr Sobecki
Hi

I'm trying to create an excel file with a data model and relationships
between tables.

The equivalent of manually setting relations in Excel via GUI:

Data -> Relationships

When extracting the .xlsx file I can see that information stored in the
xl/workbook.xml file however I cannot find it in apache POI.

Is there a way to specify data model relationships using Apache POI
(poi-ooxml:4.1.2)?


Regards,

Piotr Sobecki