操作EXCEL导出数据.doc.docx

using System;using System.Diagnostics;using System.Collections;using System.Data;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using Excel;namespace LTP.Common{///summary///操作EXCEL导出数据报表的类///李天平/// 2006.4////summarypublicclassDataToExcel {public DataToExcel() { } #region操作EXCEL的一个类(需要Excel.dll支持)privateint titleColorindex = 15;///summary///标题背景色////summarypublicint TitleColorIndex {set { titleColorindex = value; }get { return titleColorindex; } }privateDateTime beforeTime;//Excel启动之前时间privateDateTime afterTime;//Excel启动之后时间 #region创建一个Excel示例///summary///创建一个Excel示例////summarypublicvoid CreateExcel() { Excel.Application excel = new Excel.Application(); excel.Application.Workbooks.Add(true); excel.Cells[1, 1] = 第行第列; excel.Cells[1, 2] = 第行第列; excel.Cells[2, 1] = 第行第列; excel.Cells[2, 2] = 第行第列; excel.Cells[3, 1] = 第行第列; excel.Cells[3, 2] = 第行第列;//保存 excel.ActiveWorkbook.SaveAs(./tt.xls, XlFileFormat.xlExcel9795, null, null, false, false, Excel.XlSaveAsAccessMode.xlNoChange, null, null, null, null, null);//打开显示 excel.Visible = true;//excel.Quit();//excel=null; //GC.Collect();//垃圾回收 } #endregion #region将DataTable的数据导出显示为报表///summary///将DataTable的数据导出显示为报表////summary///param name=dt要导出的数据/param///param name=strTitle导出报表的标题/param///param name=FilePath保存文件的路径/param///returns/returnspublicstring OutputExcel(System.Data.DataTable dt, string strTitle, string FilePath) { beforeTime = DateTime.Now; Excel.Application excel; Excel._Workbook xBk; Excel._Worksheet xSt;int rowIndex = 4;int colIndex = 1; excel = new Excel.ApplicationClass(); xBk = excel.Workbooks.Add(true); xSt = (Excel._Worksheet)xBk.ActiveSheet;//取得列标题foreach (DataColumn col in dt.Columns) { co