Access excel file based on path

MaximP — Thu, 18 Apr 2024 15:47:24 GMT

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.

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.

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

Re: Access excel file based on path

AfeefaTk — Thu, 02 May 2024 06:07:40 GMT

Hi @MaximP

Could you please let me know which file types are you not able to read by adding path manually to the open file block?

It would be good if you could share the automation workspace and automation run json file.

Thanks

topic Access excel file based on path in Qlik Automate

Access excel file based on path

Re: Access excel file based on path