c#导出ecel方法大全

1、C粉出EXCEL方法大全C姓常需要把报表数据导出Excel,下面详细介绍6种方法：第一种方法比较罗嗦，主要介绍如何调用，含注释给不熟导出EXCE因知其原理 第二方法直接套用，代码简单明了。个人推荐这种，直接套用，非常方便。第三到第六种就不一一介绍了。方法1页面增加一个按钮，单击事件添加如下方法：protected void Button1_Click(object sender, EventArgs e)Export(application/ms-excel,学生信息列表.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)前台：读取Excel数据的代码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,直接调用页面增加一个按钮btnExcel ,

5、单击btnExcel事件添加如下方法：主要替换 GridView名称和写你的GridView数据绑定方法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=请稍后;.()；()； .

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