| 标题 | asp.net(c#)将数据导出到word或excel |
| 内容 | 最简单的方法是把页面上所有的东西都导出 在载入时调用，注意页面里不能有其它控件，包括按钮 void converttoexcel() { response.clear(); response.buffer = true; response.charset = gb2312; response.appendheader(content-disposition, attachment;filename= + datetime.now.tostring(yyyymmddhhmmss) + .xls); response.contentencoding = system.text.encoding.getencoding(gb2312); response.contenttype = application/ms-excel; this.page.enableviewstate = false; system.io.stringwriter ostringwriter = new system.io.stringwriter(); system.web.ui.htmltextwriter ohtmltextwriter = new system.web.ui.htmltextwriter(ostringwriter); this.page.rendercontrol(ohtmltextwriter); response.write(ostringwriter.tostring()); response.end(); } asp.net(c#)将数据导出到word或excel 命名空间： using system.io; using system.text; 将datagrid的数据导出到excel string excelname=excel文件名; httpcontext.current.response.charset = gb2312; httpcontext.current.response.contentencoding = encoding.utf8; httpcontext.current.response.contenttype = application/ms-excel; httpcontext.current.response.appendheader(content-disposition, attachment;filename= + excelname + .xls); dr1.page.enableviewstate = false; stringwriter sw = new stringwriter(); htmltextwriter tw = new htmltextwriter(sw); dr1.rendercontrol(tw); httpcontext.current.response.write(sw.tostring()); httpcontext.current.response.end(); 将datagrid的数据导出到word string excelname=word文件名; httpcontext.current.response.charset = gb2312; httpcontext.current.response.contentencoding = encoding.utf8; httpcontext.current.response.contenttype = application/ms-winword; httpcontext.current.response.appendheader(content-disposition, attachment;filename= + excelname + .doc); dr1.page.enableviewstate = false; stringwriter sw = new stringwriter(); htmltextwriter tw = new htmltextwriter(sw); dr1.rendercontrol(tw); httpcontext.current.response.write(sw.tostring()); httpcontext.current.response.end(); asp.net 2.0,c#----利用gridview控件导出其他文件(导出excel，导出word文件) // 注意，在visual studio2005平台下，如果使用gridview导出文件， //就必须重载verifyrenderinginserverform方法 public override void verifyrenderinginserverform(control control) { } /// /// 导出到文件的方法， /// /// model=1:导出为execl，model=2:导出为word private void tofiles(int model) { string strfilename = datetime.now.tostring(yyyymmdd-hhmmss); system.web.httpcontext hc = system.web.httpcontext.current; hc.response.clear(); hc.response.buffer = true; hc.response.contentencoding = system.text.encoding.utf8;//设置输出流为简体中文 if (model == 1) { //---导出为excel文件 hc.response.addheader(content-disposition, attachment;filename= +httputility.urlencode(strfilename, system.text.encoding.utf8) + .xls); hc.response.contenttype = application/ms-excel;//设置输出文件类型为excel文件。 } else { //--- 导出为word文件 hc.response.addheader(content-disposition, attachment;filename= +httputility.urlencode(strfilename, system.text.encoding.utf8) + .doc); hc.response.contenttype = application/ms-word;//设置输出文件类型为word文件。 } system.io.stringwriter sw = new system.io.stringwriter(); system.web.ui.htmltextwriter htw = new system.web.ui.htmltextwriter(sw); this.gridview1.rendercontrol(htw); hc.response.write(sw.tostring()); hc.response.end(); } //-导出为excel文件 protected void toexecl_click(object sender, eventargs e) { tofiles(1); } //-导出为word文件 protected void button1_click(object sender, eventargs e) { tofiles(2); } from:http://hi.baidu.com/jg_%b3%c2/blog/item/4f0edf188851c50135fa41ce.html c#操作word[转] 导入com库：microsoft word 11.0 object library. |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。