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

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();}

转载于:https://www.cnblogs.com/tuyile006/archive/2006/07/31/464202.html

相关资源：三种ASP.NET读取Excel文件的方法浅析(含完整代码)