Using GlideExcelParser to parse an Excel doc with external workbook links

Ronald Wells
Tera Expert

I have a script that uses GlideExcelParser to parse an Excel document. However, the provided Excel document has workbook links to external documents, the parsing fails with the following error:

Unable to parse excel file: Unable to load headers from the XLSX data source

When the data is copied to a clean version of the file without links, it parses properly.

How can I ignore the workbook links to external data and just parse the Excel document using the data provided on the sheet?

0 REPLIES 0