I would like to store an xlsx file in storage bucket, then read the data in two sheets of the excel file

I am trying to piece together an orchestrator app and a workflow. Originally I have used read range to read two sheets of an excel workbook stored locally, however I want to use the download storage file activity to download the excel file, save it as a variable (currently of ILocalResource type, if anyone has any better ideas please let me know), read two sheets of the excel file and pass it through a workflow. Any help would be massively appreciated

Just use the Download Storage File activity and wherever you have it put the file, use that path/filename in your Excel activities to read it.

Thankyou for your reply, I was hoping I could pass the file as a variable without storing it locally, do you know if this is possible?

No. The only file you can read directly from the Storage Bucket is a CSV. All other file types must be downloaded to a real folder.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.