DATASET数据保存到EXCEL文件（asp.net）

最新推荐文章于 2022-02-21 17:36:00 发布

weixin_33936401

最新推荐文章于 2022-02-21 17:36:00 发布

阅读量125

点赞数

public void SaveToExcel(System.Data.DataTable objTable)

{
    int CountR=objTable.Rows.Count;
    int CountC=objTable.Columns.Count;
    Response.Clear();
    Response.Buffer= true;

    //设置Http的头信息,编码格式
          Response.AppendHeader("Content-Disposition","attachment;filename=result.xls");
   Response.ContentType = "application/ms-excel";

//设置编码
Response.Charset="GB2312";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");

for (int RowNo = 0; RowNo <= CountR-1; RowNo++)
{
 string RowContent="";
 for (int CloumnNo = 0; CloumnNo <= CountC-1; CloumnNo++)
 {
 RowContent+=Convert.ToString(objTable.Rows[RowNo][CloumnNo])+"\t"; }
 RowContent+="\n";
 Response.Write(RowContent);
}
Response.End();
}