DataGrid控件的常见数据导出EXCEL技术(1)

 

绑定到DataGrid控件中的数据导出Excel表有几种比较常见的方式.现一一介绍.

方式一:直接导出,不需要任何加工.这种对那些内容只有一页,而且是纯数据不含按钮的尤其合适.

if (dgrid.Visible==false)

{

     Label5.Visible=true;   Label5.Text=" 您还没有确认导出的内容,请先查找";

}

else

{

     Label5.Visible=false;

     Response.Clear(); Response.Buffer=true; Response.Charset = "gb2312";// 导出中文字体

Response .AppendHeader("Content-Disposition","attachment;filename=YieldCompareForms.xls");

     Response.ContentEncoding=System.Text.Encoding.GetEncoding("gb2312");

     Response.ContentType="application/ms-excel";

     this.EnableViewState=false;

     // 定义一个输出流

     System.IO.StringWriter Ostring=new System.IO.StringWriter();

System .Web.UI.HtmlTextWriter ohtmlTextWrite=new System.Web.UI.HtmlTextWriter(Ostring);

// 目标数据绑定到输入输出流

this .dgrid.RenderControl(ohtmlTextWrite);

Response .Write(Ostring.ToString());       Response.End();

}

方式二:对DataGrid内容含有多页,但依然是纯数据的可采用此法.

Response .Clear ();Response.Buffer = true; Response.Charset = "gb2312";

string tablename =Session["unique_id"].ToString();// 表名以productid为名字

string str="attachment;filename="+tablename+".xls";

Response .AppendHeader("Content-Disposition",str);// 与下面这句等价

//Response.AppendHeader("Content-Disposition","attachment;filename=FileFlow.xls");

Response .ContentEncoding=System.Text.Encoding.GetEncoding("gb2312");

Response .ContentType = "application/ms-excel";

this .EnableViewState = false;

System .IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter=new System.Web.UI.HtmlTextWriter(oStringWriter);

GC .Collect ();

string strsql ="select uniqueid,testitem,testindex,result,speccount,errorcode from "+Session["projectname"].ToString()+".testiteminfo where uniqueid='"+tablename.ToString()+"' order by testindex";

string project=Session["projectname"].ToString();

OracleConnection  conn=new OracleConnection(StoneFunction.neworacleconn(project));

conn .Open();

 OracleDataAdapter OracleDa=new OracleDataAdapter(strsql,conn);

DataSet ds=new DataSet();

OracleDa .Fill(ds);

DataTable dt=ds.Tables[0];

StringWriter sw=new StringWriter();

//Excel 表格第一行

sw .WriteLine("Uniqueid/tTestitem/tTestindex/tResult/tSpeccount/tErrorcode");

foreach (DataRow dr in dt.Rows)

{

sw .WriteLine(dr["Uniqueid"]+"/t"+dr["testitem"]+"/t"+dr["testindex"]+"/t"+dr["result"]+"/t"+dr["speccount"]+"/t"+dr["errorcode"]);

}

sw .Close(); Response.Write(sw); Response.End();