导出Excel的四种方法.docx

导出excel的几种方法作者:YanJun 日期:2007-07-01字体大小: 小中大据我现在所知excel有四种方法：1.2.把web上的DataGrid直接导入到excelpublic void ExportToExcel(System.Web.UI.Control ctl) { bool CurrCtlVisible=ctl.Visible; ctl.Visible=true; Response.AppendHeader(Content-Disposition,attachment;filename=Excel.xls); Response.ContentEncoding = System.Text.Encoding.GetEncoding(GB2312); Response.ContentType = application/ms-excel; ctl.Page.EnableViewState = false; System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(tw); ctl.RenderControl(hw); Response.Write(tw.ToString()); Response.End(); ctl.Page.EnableViewState = true; ctl.Visible=CurrCtlVisible; }3.在引用里调用Microsoft.Office.Interop.Excel.dll，原理是把数据存到DataTable、DataView或DataGrid中，然后再把数据一格一格的赋到excel的cell里去。见如下代码：public class ExportToExcel {私有成员#region 私有成员 // 数据的DataView private DataView dv=null; // 表格标题 private string title=null; // 输出文件路径 private string outFilePath=null; // 输入文件名 private string inputFilePath=System.Windows.Forms.Application.StartupPath+@ emplate.xls; #endregion公共属性#region 公共属性 /**//// summary /// 数据的DataView /// /summary public DataView DV { set { dv=value; } } /**//// summary /// 表格标题 /// /summary public string Title { set { title=value; } get { return title; } } /**//// summary /// 输出文件路径 /// /summary public string OutFilePath { set { outFilePath=value; } get { return outFilePath; } } /**//// summar