C# Export GridView Data to Excel WITHOUT Formatting

[EDN Admin]

I am trying to export data into an Excel spreadsheet, but it takes the formatting with it (back colors, grid lines, etc.). Can someone tell me how I can get rid of the formatting when I export?
Here is the code I am using:
<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2 <font face="Consolas" size="2

</font></font><font face="Consolas" size="2

</font>
<span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small string<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
attachment = <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small "attachment; filename=FieldList.xls"<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small ;

Response.ClearContent();
<font face="Consolas" size="2 <font face="Consolas" size="2
Response.AddHeader(
</font></font><font face="Consolas" size="2

</font>

<span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small "content-disposition"<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small ,
attachment);<font face="Consolas" size="2 <font face="Consolas" size="2
Response.ContentType =
</font></font><font face="Consolas" size="2

</font>

<span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small "application/ms-excel"<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small ;<font face="Consolas" size="2 <font face="Consolas" size="2


</font></font><font face="Consolas" size="2

</font>

<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small StringWriter<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
sw = <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small new<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small StringWriter<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small ();<font face="Consolas" size="2 <font face="Consolas" size="2


</font></font><font face="Consolas" size="2

</font>

<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small HtmlTextWriter<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
htw = <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small new<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small HtmlTextWriter<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small (sw);

　
<font face="Consolas" size="2 <font face="Consolas" size="2

</font></font><font face="Consolas" size="2

</font>

<span style="font-family:Consolas; color:#008000; font-size:x-small <span style="font-family:Consolas; color:#008000; font-size:x-small <span style="font-family:Consolas; color:#008000; font-size:x-small // Create a form to contain the grid
<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small <font face="Consolas" size="2 <font face="Consolas" size="2

</font></font><font face="Consolas" size="2

</font>
<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small HtmlForm<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
frm = <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small <span style="font-family:Consolas; color:#0000ff; font-size:x-small new<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
<span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small <span style="font-family:Consolas; color:#2b91af; font-size:x-small HtmlForm<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small ();

grdColumnList.Parent.Controls.Add(frm);
<font face="Consolas" size="2 <font face="Consolas" size="2
frm.Attributes[
</font></font><font face="Consolas" size="2

</font>

<span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small "runat"<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small ]
= <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small <span style="font-family:Consolas; color:#a31515; font-size:x-small "server"<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small ;

frm.Controls.Add(grdColumnList);
frm.RenderControl(htw);
<font face="Consolas" size="2 <font face="Consolas" size="2

</font></font><font face="Consolas" size="2

</font>

<span style="font-family:Consolas; color:#008000; font-size:x-small <span style="font-family:Consolas; color:#008000; font-size:x-small <span style="font-family:Consolas; color:#008000; font-size:x-small //grdColumnList.RenderControl(htw);
<span style="font-family:Consolas; font-size:x-small <span style="font-family:Consolas; font-size:x-small
Response.Write(sw.ToString());
Response.End();


View the full article