Excel JS display file paths of linked workbooks

Oliver Muthusami (FYB) 0 Reputation points
2023-08-02T02:25:24.3633333+00:00

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:
User's image

await Excel.run(async (context) => { 
	context.workbook.load("linkedWorkbooks");
	await context.sync();
	const isNull = context.workbook.linkedWorkbooks.isNullObject;
	const items = context.workbook.linkedWorkbooks.items;
});
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,226 questions
0 comments No comments
{count} votes

Your answer

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