How to Export an Excel File using C#

Question

Helo, i already search on Google and here (StackOverflow) but no any solution i complete.

I Have a Excel file in my folder and i need to create a method on my controller to download this file.

And in my React Web Site i need to get this file to user computer.

I try to use ActionResult, FileStreamResult, HttpResponseMessage and other, read file from folder with File.ReadAllbytes, put the Header on response.

On the final i get this.

{ FileContents: "allcontentoffilehere....", Contenttype: "application/octet-stream", FileDownloadName: "filename.xls"}

And using this JavaScript do download:

var bytes = new Uint8Array(responseDownloadFile.data.FileContents);
                var blob = new Blob([bytes], {
                    type: responseDownloadFile.data.ContentType
                });

                const link = document.createElement('a');
                link.href = window.URL.createObjectURL(blob);
                link.download = responseDownloadFile.data.FileDownloadName;
                document.body.appendChild(link);
                link.click();

But the file when download is corrupted.

Any on can help me?

Solution from Microsoft did not work? learn.microsoft.com/en-us/dotnet/csharp/programming-guide/… — Austin G
– Austin G, Commented Oct 29, 2020 at 20:05
I assume you have generated the file and want to download it from an ASP.NET Web Api: stackoverflow.com/questions/11125535/… — Michael
– Michael, Commented Oct 29, 2020 at 20:07

eldu_gate · Accepted Answer · 2020-10-30 05:34:43Z

0

Try to return HttpResponseMessage type on your API

                HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK);
            result.Content = new ByteArrayContent([file bytes]);
            result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/file type");
            result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
            {
                FileName = "filename.xlsx"
            };

            return result;

And on your Front end execute code:

window.location.href = "link to your api endpoint to download excel";

answered Oct 30, 2020 at 5:34

eldu_gate

262 bronze badges

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

Collectives™ on Stack Overflow

How to Export an Excel File using C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related