Get Excel File IDs dynamically from folder on Sharepoint

[morgankejerhag]

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?

[Chirantha]

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

[paulcalvet]

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,