Qlik Sense SaaS - Extracting Sheet Names from an Excel file

Lachlan — Thu, 17 Feb 2022 01:43:53 GMT

We receive a regular dataset in Excel format which frequently has new sheets added. The actual Sheet Names are critical in terms of the category they contain. Each sheet has an identical structure.

How can I automatically extract a list of Sheet Names from an Excel document in Qlik Sense SaaS so I can then use them to generate a FOR EACH loop using those Sheet Names?

My Excel documents are located in Sharepoint, so I am using the Sharepoint Connector to extract them. The Sharepoint Connector displays the Sheet Names in the dialog, so the API functionality for extracting Sheet Names is already present to a degree, but this requires either manually connecting to the file each time it is updated, or manually entering any new sheet names in my FOR EACH loop.

How can I automate this so the first step after connecting to the file using the Sharepoint Connector (or some other option if available in SaaS) is to extract and list the Sheet Names contained within each Excel file so I can use them in a variable, for example?

Re: Qlik Sense SaaS - Extracting Sheet Names from an Excel file

dyy — Mon, 27 Feb 2023 22:23:33 GMT

Did you ever get a solution to this?

topic Re: Qlik Sense SaaS - Extracting Sheet Names from an Excel file in Connectivity & Data Prep

Qlik Sense SaaS - Extracting Sheet Names from an Excel file

Re: Qlik Sense SaaS - Extracting Sheet Names from an Excel file