Response.Clear();
Response.Buffer= true;

Response.AppendHeader("Content-Disposition","attachment;filename="+filename+".xls");
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.Table_Report.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());

Response.End();

首先将excel.exe copy 到 ..\Microsoft Visual Studio .NET 2003\SDK\v1.1\Bin目录下
利用TlbImp.exe生成Excel.dll cmd命令格式为 TlbImp excel.exe
在工程的com中引用Excel.dll即可

Excel.Application app = new Excel.ApplicationClass();//生成excel接口类实体
if( app == null)
{
MessageBox.Show("Excel无法启动");
return;
}
app.Visible = true;//是否显示Excel窗体,不显示的话,估计就弹出一个是否保存的窗口.明天去尝试一下
Excel.Workbooks wbs = app.Workbooks;
Excel.Workbook wb = wbs.Add(Missing.Value);
Excel.Worksheet ws = (Excel.Worksheet)wb.Worksheets[1];
Excel.Range r = ws.get_Range("A1","H1");//确定填充的范围
object [] objHeader = {"标题1","标题2","标题3",
"标题4","标题5","标题6",
"标题7","标题8"};//填充的内容
r.Value2 = objHeader;//这里的属性Value2可能有变化,我参考的文章里是Value,不知道是否和生成dll的Excel版本有关
if (lv.Items.Count >0)
{
r = ws.get_Range("A2",Missing.Value);
object [,] objData = new Object[this.lv.Items.Count,8];
foreach(ListViewItem lvi in lv.Items)
{
objData[lvi.Index,0] = lvi.SubItems[0].Text;
objData[lvi.Index,1] = lvi.SubItems[1].Text;
objData[lvi.Index,2] = lvi.SubItems[2].Text;
objData[lvi.Index,3] = lvi.SubItems[3].Text;
objData[lvi.Index,4] = lvi.SubItems[4].Text;
objData[lvi.Index,5] = lvi.SubItems[5].Text;
objData[lvi.Index,6] = lvi.SubItems[6].Text;
objData[lvi.Index,7] = lvi.SubItems[7].Text;
}//逐行导入ListViewItem中的每项,还可以逐单元的修改,很方便
r = r.get_Resize(lv.Items.Count,8);
r.Value2 = objData;
r.EntireColumn.AutoFit(); //这个是用来自动调整单元格宽度的
}
app = null;//丢弃该实体