C
C#

help

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 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 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? 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.

Looking for more? Join the community!

Want results from more Discord servers?
Add your server
Recommended Posts
LeetCode - Clone Graph [Answered]Hey, trying to solve - https://leetcode.com/problems/clone-graph/ basically - question is to deep-cHow to save time on multiple file zippingHiya. I have a tool that builds and copies files into specified directory and then zips them. It is Help recquired please! I got stuck at using ui controls like dropdowns and radio buttons im .net corHi, I got stuck in using ui such as Drop-down list and radio buttons for binding data from db and toBlazor Components not renderingFor some reason, sometimes the UI components simply refuse to render No Exceptions, No Errors, NothiEnumerable merging with EnumerableHello I have a function getObjects() and I have a large parameters list that I have to pass in blockdotnet format and jetbrains rulesI'm wondering if it is possible for `dotnet format` to include ReSharper rules from .editconfig. I Variable ValidationWhat are the advantages/disadvantages between both of these bits of code to validate the correct inpI don't understand what this is asking for at all (sry for bad title) [Answered]```Create a Sieve class with a public bool IsGood(int number) method. This class needs a constructorHow to convert a Predicate to ExpressionHi friends, I have the method bellow My Question is is there any way or technique to `Convert` thatRemote robot state and commands - best patterns, practices?I have a use case where I'm able to remotely control a robot via a SPA frontend and dotnet API + robInject AppDbContext with parameterized constructorI'm trying to encapsulate the AppDbContext, so everything needed is passed in the constructor. ```cHow does `internal` work in this code? [Answered]```cs public class BaseClass { // Only accessible within the same assembly. internal statiHow to return a named predicatesHi friends, I want to build a `Method` that returns a set of `Predicates` **Example:** ```cs prTCP - The IO operation has been aborted because of either a thread exit or an application requestHello, I am trying to implement a class that connects to a server through TCP, receives a message, oMinimal Api AttributesThe testcode in my screenshot doesnt call the IAuthorizationFilter implementing attribute on my methWhat's a repository and the repository pattern? [Answered]Some articles are telling me that a repository is in essence just an interface that abstracts data aNewtonsoft.Json deserialize issue [Answered]I have a json string. For example this one: ```json {"type":"accept","id":0,"ms_id":"00000","user_idNeed help converting xml to C [Answered]https://api.privatbank.ua/p24api/pboffice?city=%D0%94%D0%BD%D0%B5%D0%BF%D1%80%D0%BE%D0%BF%D0%B5%D1%8List as a field of an object. [Answered]``` public class Character { public string? Id { get; set; } // Identifier. publCapturing images from specific DirectX windowI want to capture images (pretty quickly, so pretty much like a video) from different applications,