Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MaximP
Contributor
Contributor

Access excel file based on path

TLDR : I want to access an Excel file based on a sharepoint path I give manually.

What I've tried : you can give to a "Open file on Microsoft Sharepoint" component a path directly linking to a document, and then use a "Read Data From File on MS" to open it but it only works for CSV and JSON documents. 

MaximP_1-1713454337073.png

 

You can also acces the document based on a Drive ID and Item ID with a "List Rows With Headers" for example. This solution however needs me to access every item of the file tree until i get to the file containing the excel wich is not really sustainable. 

MaximP_3-1713454808243.png

 

So I would need a component that either open an xlsx document based on a path or give a Drive ID and Item ID based on a path.

Any other idea would help.

Thanks in advance,

Maxim Perolle

 

 

 

Labels (3)
0 Replies