Read Excel File From Stream Asp.Net Core WebAPI

Question

I'm working with asp.net core webapi and I want to post an excel file from client (using Angular 2) to my Controller. I've read Import Excel example but what they've done is use an existing file. I want to know how can I read an excel file using IO.Stream. Thanks for your help. I've started read a .txt file like this:

public string Post()
    {
        var files = Request.Form.Files;
        if(files != null)
        {

            var stream = files[0].OpenReadStream();
            StreamReader reader = new StreamReader(stream);

            string result = reader.ReadToEnd();
            int a;
            return result;
        }
        return "";
    }

Vitaliy Fedorchenko · Accepted Answer · 2017-04-11 16:25:19Z

3

As I understand you're trying to use EPPlus library (one of the ports compatible with .NET Core). ExcelPackage class has an overload that accepts Stream with existing Excel content (only OpenXML-based XLSX):

using (ExcelPackage package = new ExcelPackage(stream)) {
   ...
}

answered Apr 11, 2017 at 16:25

Vitaliy Fedorchenko

9,3253 gold badges42 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Justin Van Over a year ago

I've just installed it to my project and I've found the overload constructor as you've suggested me. Anyway, Many thanks for your help!

Collectives™ on Stack Overflow

Read Excel File From Stream Asp.Net Core WebAPI

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related