Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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