C#导出GridView数据到Excel文件类实例
程序员文章站
2023-12-13 10:08:46
本文实例讲述了c#导出gridview数据到excel文件类。分享给大家供大家参考。具体如下:
这段c#代码自定义了一个封装类,用于将gridview数据导出到excel...
本文实例讲述了c#导出gridview数据到excel文件类。分享给大家供大家参考。具体如下:
这段c#代码自定义了一个封装类,用于将gridview数据导出到excel文件
using system; using system.web; using system.web.ui; using system.io; using system.web.ui.webcontrols; namespace dotnet.utilities { public class exportexcel { protected void exportdata(string strcontent, string filename) { filename = filename + datetime.now.year.tostring() + datetime.now.month.tostring() + datetime.now.day.tostring() + datetime.now.hour.tostring() + datetime.now.minute.tostring() + datetime.now.second.tostring() + datetime.now.millisecond.tostring(); httpcontext.current.response.clear(); httpcontext.current.response.charset = "gb2312"; httpcontext.current.response.contenttype = "application/ms-excel"; httpcontext.current.response.contentencoding = system.text.encoding.utf8; //this.page.enableviewstate = false; // 添加头信息,为"文件下载/另存为"对话框指定默认文件名 httpcontext.current.response.addheader("content-disposition", "attachment; filename=" + filename + ".xls"); // 把文件流发送到客户端 httpcontext.current.response.write("<html><head><meta http-equiv=content-type content=\"text/html; charset=utf-8\">"); httpcontext.current.response.write(strcontent); httpcontext.current.response.write("</body></html>"); // 停止页面的执行 //response.end(); } /// <summary> /// 导出excel /// </summary> /// <param name="obj"></param> public void exportdata(gridview obj) { try { string style = ""; if (obj.rows.count > 0) { style = @"<style> .text { mso-number-format:\@; } </script> "; } else { style = "no data."; } httpcontext.current.response.clearcontent(); datetime dt = datetime.now; string filename = dt.year.tostring() + dt.month.tostring() + dt.day.tostring() + dt.hour.tostring() + dt.minute.tostring() + dt.second.tostring(); httpcontext.current.response.addheader("content-disposition", "attachment; filename=exportdata" + filename + ".xls"); httpcontext.current.response.contenttype = "application/ms-excel"; httpcontext.current.response.charset = "gb2312"; httpcontext.current.response.contentencoding = system.text.encoding.getencoding("gb2312"); stringwriter sw = new stringwriter(); htmltextwriter htw = new htmltextwriter(sw); obj.rendercontrol(htw); httpcontext.current.response.write(style); httpcontext.current.response.write(sw.tostring()); httpcontext.current.response.end(); } catch { } } } }
希望本文所述对大家的c#程序设计有所帮助。