c#導(dǎo)出ecel方法大全

1、C粉出EXCEL方法大全C姓常需要把報(bào)表數(shù)據(jù)導(dǎo)出Excel,下面詳細(xì)介紹6種方法：第一種方法比較羅嗦，主要介紹如何調(diào)用，含注釋給不熟導(dǎo)出EXCE因知其原理 第二方法直接套用，代碼簡(jiǎn)單明了。個(gè)人推薦這種，直接套用，非常方便。第三到第六種就不一一介紹了。方法1頁面增加一個(gè)按鈕，單擊事件添加如下方法：protected void Button1_Click(object sender, EventArgs e)Export(application/ms-excel,學(xué)生信息列表.xls);private void Export(string FileType, string FileName)=GB

2、2312;= (Content-Disposition, attachment;filename= + (FileName, .ToString();=FileType;=false;StringWriter tw = new StringWriter();HtmlTextWriter hw = new HtmlTextWriter(tw);(hw);();();1 ls);private void Export(string FileType, string FileName)=GB2312;= (Content-Disposition, attachment;filename= + (Fi

3、leName, .ToString();=FileType;=false;StringWriter tw = new StringWriter();HtmlTextWriter hw = new HtmlTextWriter(tw);(hw);();();public override void VerifyRenderingInServerForm(Control control)前臺(tái)：讀取Excel數(shù)據(jù)的代碼private DataSet CreateDataSource()string strCon;strCon = Provider= Source= + () + ; Extended

4、Properties=Excel ;OleDbConnection olecon = new OleDbConnection(strCon);OleDbDataAdapter myda = new OleDbDataAdapter(SELECT * FROM Sheet1$, strCon);DataSet myds = new DataSet();(myds);return myds;protected void Button1_Click(object sender, EventArgs e)=CreateDataSource();();方法2,直接調(diào)用頁面增加一個(gè)按鈕btnExcel ,

5、單擊btnExcel事件添加如下方法：主要替換 GridView名稱和寫你的GridView數(shù)據(jù)綁定方法BindGrid()就行了。protected void btnExcel_Click( object sender, EventArgs e)(ToExcel; ls);=utf-8;=utf-8);= application/ms-excel ;alue=i+ 1;for (int j= 1;j;j+)parmj.Value =ij;()；rowRead+;percent=( float )( 100*rowRead)/totalCount;； .;if (i=請(qǐng)稍后;.()；()； .

6、;.();range= 2,1, = true ;(FileName);dt= new filePath= d:;object oMissing = xlApp = new();try=false ;=false ;oBooks =;xlWorkbook = null ;xlWorkbook =(filePath,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing, oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissi ng)；xlWorksheet;oString(); TOC o 1-5 h z if ( k -1 )stringBuffer +=t;stri