topic Get Excel File IDs dynamically from folder on Sharepoint in Qlik Automate

Get Excel File IDs dynamically from folder on Sharepoint

morgankejerhag — Mon, 10 Jul 2023 12:02:01 GMT

I want to create an automation that iterates over Excel files in a folder on Sharepoint. For each file found the Excel file should be opened and a Worksheet (always the same name) should be read. I can list all Excel files in the folder (List Files on Microsoft Sharepoint with a path, but Excel's List Rows from Worksheet requires a File ID. I can find the FIle ID manually by lookup, but how do I find it automatically from all files in the folder?

Re: Get Excel File IDs dynamically from folder on Sharepoint

Chirantha — Tue, 11 Jul 2023 08:11:02 GMT

Hey Morgan,

You can try to use the Qlik Web Connector to list all Excel files in a folder on SharePoint. You can then use the ListFiles table to identify the ID of each Excel file as discussed here. Once you have the file IDs, you can try to use the ''List Rows from Worksheet'' function to read the data from a specific worksheet in each file

Re: Get Excel File IDs dynamically from folder on Sharepoint

paulcalvet — Tue, 04 Jun 2024 15:11:34 GMT

Hello @Chirantha

I try all the possibilities but I don't find how work list file for Sharepoint Connector.

The path is always wrong, how can I find the right path ?

Thanks,