Microsoft 365 and Office | Development | Other
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Is it possible to retrieve file paths of linked Excel workbooks using the Office JS API (Excel js)?
I can see a LinkedWorkbook property, however, the isNull value returns true and the getItems function returns undefined., so I can't iterate over the linked workbooks.
As you can see, I do have a linked workbook in the Excel sheet that I am currently working on:
await Excel.run(async (context) => {
context.workbook.load("linkedWorkbooks");
await context.sync();
const isNull = context.workbook.linkedWorkbooks.isNullObject;
const items = context.workbook.linkedWorkbooks.items;
});