public static void ExportExcelFile(System.Data.DataTable myTable)
{
if(myTable != null)
{
System.Web.UI.WebControls.DataGrid dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(dgExport_ItemDataBound);
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
curContext.Response.Clear();
curContext.Response.Buffer= true;
curContext.Response.Charset="GB2312";
curContext.Response.AppendHeader("Content-Disposition","attachment;filename=FileName.xls");
curContext.Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
curContext.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dgExport.DataSource = myTable;
dgExport.DataBind();
dgExport.RenderControl(oHtmlTextWriter);
curContext.Response.Write(oStringWriter.ToString());
curContext.Response.End();
}
}
private static void dgExport_ItemDataBound(object sender,System.Web.UI.WebControls.DataGridItemEventArgs e)
{
e.Item.Cells[1].Attributes.Add("style","vnd.ms-excel.numberformat:@"); //规定单元格类型去掉Excel中的科学计数法
e.Item.Cells[3].Attributes.Add("style","vnd.ms-excel.numberformat:@");
e.Item.Cells[5].Attributes.Add("style","vnd.ms-excel.numberformat:@");
}
{
if(myTable != null)
{
System.Web.UI.WebControls.DataGrid dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(dgExport_ItemDataBound);
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
curContext.Response.Clear();
curContext.Response.Buffer= true;
curContext.Response.Charset="GB2312";
curContext.Response.AppendHeader("Content-Disposition","attachment;filename=FileName.xls");
curContext.Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
curContext.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dgExport.DataSource = myTable;
dgExport.DataBind();
dgExport.RenderControl(oHtmlTextWriter);
curContext.Response.Write(oStringWriter.ToString());
curContext.Response.End();
}
}
private static void dgExport_ItemDataBound(object sender,System.Web.UI.WebControls.DataGridItemEventArgs e)
{
e.Item.Cells[1].Attributes.Add("style","vnd.ms-excel.numberformat:@"); //规定单元格类型去掉Excel中的科学计数法
e.Item.Cells[3].Attributes.Add("style","vnd.ms-excel.numberformat:@");
e.Item.Cells[5].Attributes.Add("style","vnd.ms-excel.numberformat:@");
}