.NET开发不可不知、不可不用的辅助类（三）（报表导出---终结版）

http://www.cnblogs.com/wuhuacong/archive/2007/12/03/981520.html

 

.NET导出报表一般是采用导出Excel报表的方式输出内容。而这又分为两种方式：使用Excel模板方式和使用网页输出Excel格式两种。
首先介绍简单的一种，网页输出Excel内容，这种不需要引用Excel的程序集。
/**//// <summary> /// 报表导出辅助类 /// </summary> public class ExportToExcel { 字段信息#region 字段信息 private const string C_HTTP_HEADER_CONTENT = "Content-Disposition"; private const string C_HTTP_ATTACHMENT = "attachment;filename="; private const string C_HTTP_CONTENT_TYPE_EXCEL = "application/ms-excel"; private string charSet = "utf-8"; private string fileName = "Report"; private string title = ""; private DataTable sourceTable; /**//// <summary> /// 输出的字符集，默认为gb2312 /// </summary> public string CharSet { get { return charSet; } set { charSet = value; } } /**//// <summary> /// 输出的Excel报表文件名称 /// </summary> public string FileName { get { return fileName; } set { fileName = value; } } /**//// <summary> /// 报表内容的抬头 /// </summary> public string Title { get { return title; } set { title = value; } } /**//// <summary> /// 报表数据的DataTable /// </summary> public DataTable SourceTable { get { return sourceTable; } set { sourceTable = value; } } #endregion public ExportToExcel() { } /**//// <summary> /// 带参数的构造函数 /// </summary> /// <param name="fileName">导出的Excel文件名</param> /// <param name="sourceTable">源数据DataTable</param> /// <param name="title">报表的抬头</param> public ExportToExcel(string fileName, DataTable sourceTable, string title) { this.fileName = fileName; this.sourceTable = sourceTable; this.title = title; } public void ExportReport() { if (SourceTable == null || SourceTable.Rows.Count == 0) { return; } DataGrid dataGrid = new DataGrid(); dataGrid.DataSource = sourceTable; dataGrid.DataBind(); HttpResponse Response = HttpContext.Current.Response; Response.Clear(); Response.Buffer = true; Response.AddHeader(C_HTTP_HEADER_CONTENT, C_HTTP_ATTACHMENT + HttpUtility.UrlEncode(fileName + ".xls")); Response.ContentType = C_HTTP_CONTENT_TYPE_EXCEL; Response.ContentEncoding = Encoding.GetEncoding("gb2312"); Response.Charset = charSet; StringWriter oStringWriter = new StringWriter(); HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter); dataGrid.RenderControl(oHtmlTextWriter); string str = oStringWriter.ToString(); int trPosition = str.IndexOf("<tr>", 0); string str1 = str.Substring(0, trPosition - 1); string str2 = str.Substring(trPosition, str.Length - trPosition); string str3 = "/r/n/t<tr>"; str3 += "/r/n/t/t<td align=/"center/" colspan=/"" + sourceTable.Rows.Count + "/" style="/" mce_style="/""font-size:14pt; font-weight:bolder;height:30px;/">" + title + "</td>"; str3 += "/r/n/t</tr>"; Response.Write(str1 + str3 + str2); Response.End(); } }使用时候代码如下： private void btnExport2_Click(object sender, EventArgs e) { DataTable table = SelectAll().Tables[0]; ExportToExcel export = new ExportToExcel("TestExport", table, "TestExport"); export.ExportReport(); } public static DataSet SelectAll() { string sqlCommand = " Select ID, Name, Age, Man, CONVERT(CHAR(10), Birthday ,120) as Birthday from Test"; DataSet ds = new DataSet(); string connectionString = "Server=localhost;Database=Test;uid=sa;pwd=123456"; SqlDataAdapter adapter = new SqlDataAdapter(sqlCommand, connectionString); adapter.Fill(ds); return ds; }