Excel data in Azure Storage

[JoseJoseph]

Is it possible to get the rows in an excel file stored in Azure BLOB storage so that it can be inserted into SQL  database

[manuelstgomes]

Hi @JoseJoseph 

Yes, it is. There's a BLOB storage connector:

https://emea.flow.microsoft.com/en-us/connectors/shared_azureblob/azure-blob-storage/

It's a premium connector, so you need to check if your license supports these connectors.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[JoseJoseph]

My actual concern is about  How to get the excel rows from the file stored in BLOB

[manuelstgomes]

HI @JoseJoseph 

My suggestion is to copy the file to a temp folder, check the data, and then remove the file.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel