/// <summary>
/// GridView数据导出到Excel表
/// </summary>
/// <param name="ctl">DataGrid控件</param>
/// <param name="fileName">文件名</param>
/// <param name="style">样式</param>
protected void DGToExcel(Control ctl, string fileName, string style)
{
StringBuilder sbStyle = new StringBuilder();
switch (style)
{
case "text":
sbStyle.Append(@"<style> .text { mso-number-format:/@; } </script> ");
break;
case "General":
sbStyle.Append(@"<style> .General { mso-number-format:General; } </script> ");
break;
default:
sbStyle.Append(@"");
break;
}
fileName = fileName + DateTime.Now.ToString("yyyyMMddHHmmss");
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlPathEncode(fileName) + ".xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//Response.ContentEncoding = System.Text.Encoding.Default;
//设置输出文件类型为excel文件。
Response.ContentType = "application/ms-excel";
Response.Cache.SetCacheability(HttpCacheability.Private);
StringWriter oStringWriter = new StringWriter();
HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
ctl.RenderControl(oHtmlTextWriter);
if (sbStyle.ToString().Trim() != "") Response.Output.Write(sbStyle);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
}
Question:
如果直接导出,可能将原来一些GridView中String类型的数据强制转换成int类型(例:0001解析为1)
解决方法:
这个问题可以通过把css添加到输出流中来解决。为了使ID列正确显示,您需要将其储存为文本格式。Excel中的文本格式表示为"mso-number-format:"/@",将要导出的GridView相应列的class属性设置为text。
STEP 1:
protected void grid_ItemDataBoundForExport(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemIndex > -1)
{
//通过”style”变量来控制GridView列的样式。
e.Item.Cells[1].Attributes.Add("class", "text");
}
}
STEP 2:
DGToExcel(ctl,fileName,"text");