自己修改后的一个数据导出到Excel的方法,粘出来与大家共享.
只需要将 System.Web.HttpContext.Current.Response.Charset = System.Web.HttpContext.Current.Response.Buffer = System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding( System.Web.HttpContext.Current.Response.AppendHeader( System.Web.HttpContext.Current.Response.ContentType = DataRow[] myRow = dt.Select();
;
; k < dt.Columns.Count; k++)
{
))
{
colHeaders += dt.Columns[k].ToString() + }
{
colHeaders += dt.Columns[k].ToString() + }
}
System.Web.HttpContext.Current.Response.Output.Write(colHeaders);
{
; i < cl; i++)
{
))
{
ls_item += row[i].ToString().Replace( }
{
ls_item += row[i].ToString().Replace( }
}
System.Web.HttpContext.Current.Response.Output.Write(ls_item);
ls_item = }
System.Web.HttpContext.Current.Response.Output.Flush();
System.Web.HttpContext.Current.Response.End();
}