【实例简介】
【实例截图】
【核心代码】
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");
}
}