Reading file content from Azure Blob Storage

BBokoGanga8/29/2022
Hey devs,
I have a an excel file stored on blob storage. I need to read its content directly in a service. I have access to the direct download url for the file. Any leads on how to read its content?
BBinto868/29/2022
So the question is how to read excel file?
Pphaseshift8/29/2022
seems like it
BBokoGanga8/29/2022
from a URL not a downloaded file in a directory
BBokoGanga8/29/2022
is it mandatory to inject the HttpClient into the service? This is a service linked to an API controller
Pphaseshift8/29/2022
you cant read file data from a url
CCisien8/29/2022
you'll have to download it in some form or another
CCisien8/29/2022
even if it's just to a temp folder
BBokoGanga8/29/2022
I see. That's what I needed to know. Thanks a lot.
YYawnder8/29/2022
You don't have to persist it, but you do have to download it. It can stay in a memory stream for example.
BBokoGanga8/29/2022
That's what I was trying to achieve. Download the file as stream into memory, and then get the data as byte[] without the need to download the file into the root directory.
YYawnder8/29/2022
Then do so?
YYawnder8/29/2022
As they mentioned earlier, you will still have to download it.
BBinto868/29/2022
The excel parsing libraries won't be happy about it tho
YYawnder8/29/2022
Sure it will
BBokoGanga8/29/2022
I will look into it. As for the excel parsing libraries im using, they accept streams to parse the data. I don't know if this will be doable or not. Will see how it goes
YYawnder8/29/2022
It is doable. I've done it.
BBokoGanga8/29/2022
Perfect. Thanks a lot.