how to add table relations in an excel addin

Nils 1 Reputation point
2022-06-20T08:48:07.263+00:00

Hi,

I'm using an JS excel addin to create multiple tables that are used as a data source for a pivot table. Manually or using a VB-script you can create relations between the tables:
212819-image.png

Is there a way to create these relations through the addin? I've checked the Excel JavaScript API documentation, but I didn't find any mention of table relations.

Microsoft 365 and Office | Development | Other
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.