Read Data From Excel file uploaded to Orchestrator Storage Bucket

Help Studio
, , ,
1

Hi Guys,

How can store data i got from excel file from storage bucket in variable with Datatable Type, it just can store as string after that i cant use read range.

i used “Read Storage Text” Activity.

2

You can’t use ‘Read Storage Text’ to read an Excel file uploaded to a Storage bucket. That basically just reads the file as a string. Try doing that to a real Excel file, open it in Notepad and see what you get.

The Excel Application Scope, which you can use to read the data in an Excel file, can only accept file paths. You need to download the Excel file from the storage bucket to somewhere, for example the C drive and then read it from there.

3

thanks, @Jon_Smith