asp.net 导出数据到Excel文件

asp.net 导出数据到Excel文件

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page 
{

    

    ExcelHelper.ExcelHelper excel =null;//

    protected void Page_Load（object sender EventArgs e）
    {
        excel = new ExcelHelper.ExcelHelper（Server.MapPath（“tempt/BJStock.xls“） Server.MapPath（“ExcelFile/test.xls“））;
    }

    protected void Button1_Click（object sender EventArgs e）
    {
        excel.DataTableToExcel（DbHelperSQL.DbHelperSQL.GetDataTable（“select * from excel“） 2 1 2 “Sheet“）;
        Response.Redirect（“ExcelFile/test.xls“）;
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件      24382  2009-03-24 22:28  Excel\App_Code\DbHelperSQL.cs

     文件      12219  2009-03-24 23:23  Excel\App_Code\Excel.cs

     文件    1048576  2009-03-24 23:28  Excel\App_Data\ExcelProject_Data.MDF

     文件    1048576  2009-03-24 23:28  Excel\App_Data\ExcelProject_Log.LDF

     文件    1093632  2004-05-18 17:58  Excel\Bin\Interop.Excel.dll

     文件      64288  2008-12-23 20:11  Excel\Bin\Microsoft.Vbe.Interop.dll

     文件     416544  2008-12-23 20:11  Excel\Bin\Office.dll

     文件        521  2009-03-24 22:36  Excel\Default.aspx

     文件        798  2009-03-24 23:26  Excel\Default.aspx.cs

     文件      13824  2009-03-24 23:24  Excel\ExcelFile\test.xls

     文件      13824  2009-03-24 22:21  Excel\tempt\BJStock.xls

     文件       2009  2009-03-24 22:46  Excel\Web.Config

     目录          0  2009-03-24 23:23  Excel\App_Code

     目录          0  2009-03-24 23:29  Excel\App_Data

     目录          0  2009-03-24 22:10  Excel\Bin

     目录          0  2009-03-24 23:24  Excel\ExcelFile

     目录          0  2009-03-24 22:21  Excel\tempt

     目录          0  2009-03-24 23:26  Excel

----------- ---------  ---------- -----  ----

              3739193                    18