Essa semana tive que exportar os dados de uma GridView para uma planilha Excel, bom… sabia que n\u00e3o era algo muito complicado, mas tamb\u00e9m nunca tinha feito, sendo assim realizei uma busca no grande mestre Google e encontrei uma classe que me atendeu muito bem. F\u00e1cil e descomplicado.<\/p>\n
using<\/p>\n
using System;<\/span><\/p>\n
using System.Data;<\/span><\/p>\n
using\u00a0System.Configuration;<\/span><\/p>\n
using\u00a0System.IO;<\/span><\/p>\n
using\u00a0System.Web;<\/span><\/p>\n
using\u00a0System.Web.Security;<\/span><\/p>\n
using\u00a0System.Web.UI;<\/span><\/p>\n
using\u00a0System.Web.UI.WebControls;<\/span><\/p>\n
using\u00a0System.Web.UI.WebControls.WebParts;<\/span><\/p>\n
using System.Web.UI.HtmlControls;<\/span><\/p>\n
namespace SGM.CTA.Web.UI<\/span><\/p>\n
{<\/p>\n
public<\/span><\/span>class<\/span><\/span>GridViewExportUtil<\/span><\/span><\/p>\n
{<\/p>\n
\/\/\/<\/span><\/span><summary><\/span><\/span><\/p>\n
\/\/\/<\/span><\/span> Realiza a exportao de grid para Excell<\/span><\/span><\/p>\n
\/\/\/<\/span><\/span><\/summary><\/span><\/span><\/p>\n
\/\/\/<\/span><\/span><param name=”fileName”><\/span><\/span>Nome do Arquivo<\/span><\/span><\/param><\/span><\/span><\/p>\n
\/\/\/<\/span><\/span><param name=”gv”><\/span><\/span>GridView preenchida com os dados necessrios<\/span><\/span><\/param><\/span><\/span><\/p>\n
public<\/span><\/span>static<\/span><\/span>void<\/span><\/span> Export(<\/span>string<\/span><\/span> fileName, GridView gv)<\/span><\/p>\n
{<\/p>\n
HttpContext.Current.Response.Clear();<\/p>\n
HttpContext.Current.Response.AddHeader(<\/p>\n
“content-disposition”<\/span><\/span>, <\/span>string<\/span><\/span>.Format(<\/span>“attachment; filename={0}”<\/span><\/span>, fileName));<\/span><\/p>\n
HttpContext.Current.Response.ContentType =<\/p>\n
“application\/ms-excel”<\/span><\/span>;<\/span><\/p>\n
using<\/span><\/span> (<\/span>StringWriter<\/span><\/span> sw = <\/span>new<\/span><\/span>StringWriter<\/span><\/span>())<\/span><\/p>\n
{<\/p>\n
using<\/span><\/span> (HtmlTextWriter htw = <\/span>new<\/span><\/span> HtmlTextWriter(sw))<\/span><\/p>\n
{<\/p>\n
\/\/\u00a0 Create a form to contain the grid<\/span><\/span><\/p>\n
Table table =<\/p>\n
new<\/span><\/span> Table();<\/span><\/p>\n
\/\/\u00a0 add the header row to the table<\/span><\/span><\/p>\n
if<\/span><\/span> (gv.HeaderRow != <\/span>null<\/span><\/span>)<\/span><\/p>\n
{<\/p>\n
\/\/adiciona a cor<\/span><\/span><\/p>\n
gv.HeaderRow.BackColor = System.Drawing.Color.AliceBlue;<\/p>\n
\/\/Prepara informao header<\/span><\/span><\/p>\n
GridViewExportUtil.PrepareControlForExport(gv.HeaderRow);<\/p>\n
table.Rows.Add(gv.HeaderRow);<\/p>\n
}<\/p>\n
\/\/\u00a0 add each of the data rows to the table<\/span><\/span><\/p>\n
foreach<\/span><\/span> (GridViewRow row <\/span>in<\/span><\/span> gv.Rows)<\/span><\/p>\n
{<\/p>\n
GridViewExportUtil.PrepareControlForExport(row);<\/p>\n
table.Rows.Add(row);<\/p>\n
}<\/p>\n
\/\/\u00a0 add the footer row to the table<\/span><\/span><\/p>\n
if<\/span><\/span> (gv.FooterRow != <\/span>null<\/span><\/span>)<\/span><\/p>\n
{<\/p>\n
GridViewExportUtil.PrepareControlForExport(gv.FooterRow);<\/p>\n
table.Rows.Add(gv.FooterRow);<\/p>\n
}<\/p>\n
\/\/\u00a0 render the table into the htmlwriter<\/span><\/span><\/p>\n
table.RenderControl(htw);<\/p>\n
\/\/\u00a0 render the htmlwriter into the response<\/span><\/span><\/p>\n
HttpContext.Current.Response.Write(sw.ToString());<\/p>\n
HttpContext.Current.Response.End();<\/p>\n
}<\/p>\n
}<\/p>\n
}<\/p>\n
\/\/\/<\/span><\/span><summary><\/span><\/span><\/p>\n
\/\/\/<\/span><\/span> Replace any of the contained controls with literals<\/span><\/span><\/p>\n
\/\/\/<\/span><\/span><\/summary><\/span><\/span><\/p>\n
\/\/\/<\/span><\/span><param name=”control”><\/param><\/span><\/span><\/p>\n
private<\/span><\/span>static<\/span><\/span>void<\/span><\/span> PrepareControlForExport(Control control)<\/span><\/p>\n
{<\/p>\n
for<\/span><\/span> (<\/span>int<\/span><\/span> i = 0; i < control.Controls.Count; i++)<\/span><\/p>\n
{<\/p>\n
Control current = control.Controls[i];<\/p>\n
if<\/span><\/span> (current <\/span>is<\/span><\/span> LinkButton)<\/span><\/p>\n
{<\/p>\n
control.Controls.Remove(current);<\/p>\n
control.Controls.AddAt(i,<\/p>\n
new<\/span><\/span> LiteralControl((current <\/span>as<\/span><\/span> LinkButton).Text));<\/span><\/p>\n
}<\/p>\n
else<\/span><\/span>if<\/span><\/span> (current <\/span>is<\/span><\/span> ImageButton)<\/span><\/p>\n
{<\/p>\n
control.Controls.Remove(current);<\/p>\n
control.Controls.AddAt(i,<\/p>\n
new<\/span><\/span> LiteralControl((current <\/span>as<\/span><\/span> ImageButton).AlternateText));<\/span><\/p>\n
}<\/p>\n
else<\/span><\/span>if<\/span><\/span> (current <\/span>is<\/span><\/span> HyperLink)<\/span><\/p>\n
{<\/p>\n
control.Controls.Remove(current);<\/p>\n
control.Controls.AddAt(i,<\/p>\n
new<\/span><\/span> LiteralControl((current <\/span>as<\/span><\/span> HyperLink).Text));<\/span><\/p>\n
}<\/p>\n
else<\/span><\/span>if<\/span><\/span> (current <\/span>is<\/span><\/span> DropDownList)<\/span><\/p>\n
{<\/p>\n
control.Controls.Remove(current);<\/p>\n
control.Controls.AddAt(i,<\/p>\n
new<\/span><\/span> LiteralControl((current <\/span>as<\/span><\/span> DropDownList).SelectedItem.Text));<\/span><\/p>\n
}<\/p>\n