Export html table to Excel file using ASP.NET MVC

Question

I want to export my string html table to excel. When trying to export and when I click save I get the following exception

The server can not add the header after sending the HTTP headers

This is my html table :

string tab = "<table cellpadding='5' style='border:1px solid black; border-collapse:collapse'>";
tab += "<tr><td style=' border-width:1px;border-style:solid;border-color:black;'>NumClient</td><td style=' border-width:1px;border-style:solid;border-color:black;'>Raison Sociale</td></tr>";
tab += "<tr><td style='border-width:1px;border-style:solid;border-color:black;'>" + NumClient + "</td><td style='border-width:1px;border-style:solid;border-color:black;'>"
+ Rs + "</td><td style='border-width:1px;border-style:solid;border-color:black;text-align:right;'> </td></tr>";
tab += "</table>";

This is Controller code :

 Response.ClearContent();   
 Response.AddHeader("Content-Disposition", "attachment; filename=Reliquat.csv");
 Response.ContentType = "text/csv";
 Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
 Response.Write(tab);
 Response.End();

And when I click continue I get an excel file that contains html code:

<table cellpadding='5' style='border:1px solid black; border-collapse:collapse'>";
tab += "<tr><td style=' border-width:1px;border-style:solid;border-color:black;'>NumClient</td><td style=' border-width:1px;border-style:solid;border-color:black;'>Raison Sociale</td></tr>

Does anyone have a solution for this?

The content type is incorrect. You might want to change it to application/excel and use Reliquat.xslx as file name — Hatjhie
– Hatjhie, Commented May 20, 2016 at 9:09
Alright. I think the posted reply below would be able to answer your question. You could give it a try. — Hatjhie
– Hatjhie, Commented May 20, 2016 at 9:32
Change your code to: Response.ClearContent(); Response.ClearHeaders(); Response.BufferOutput = true; Response.ContentType = "application/excel"; Response.AddHeader("Content-Disposition", "attachment; filename=Reliquat.xslx"); Response.Write(tab); Response.Flush(); Response.Close(); Response.End(); — Hatjhie
– Hatjhie, Commented May 20, 2016 at 9:34
Don't use Response.End() stackoverflow.com/questions/1087777/… — StuperUser
– StuperUser, Commented May 20, 2016 at 9:59

chrki · Accepted Answer · 2016-05-20 09:41:16Z

1

You might want to use the codes below. Hopefully, it works.

Response.ClearContent(); 
Response.ClearHeaders(); 
Response.BufferOutput = true; 
Response.ContentType = "application/excel"; 
Response.AddHeader("Content-Disposition", "attachment; filename=Reliquat.xslx"); 
Response.Write(tab); 
Response.Flush(); 
Response.Close(); 
Response.End();

From here: http://www.codescratcher.com/asp-net/export-html-excel-asp-net/

edited May 20, 2016 at 9:41

chrki

6,3436 gold badges39 silver badges60 bronze badges

answered May 20, 2016 at 9:04

Jernej Pirc

5141 gold badge4 silver badges13 bronze badges

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

6 Comments

Jernej Pirc Over a year ago

This is Web Forms sample but you can change it to work with MVC

Sarra Over a year ago

Thanks Jernej , but I don't understand webForms very well ,Have you an example with MVC ? :)

Sarra Over a year ago

when I tried the code bellow , I got the following exception : Remote host closed the connection. The error code is 0x80070057.

Sarra Over a year ago

I got the first exception : The server can not add the header after sending the HTTP headers

Sarra Over a year ago

I solved the problem by deleting @Html.AntiForgeryToken() but I did'nt understand why

|

Collectives™ on Stack Overflow

Export html table to Excel file using ASP.NET MVC

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related