基本信息
源码名称:asp.net 导出数据到Excel文件
源码大小:0.36M
文件格式:.rar
开发语言:C#
更新时间:2016-02-01
   友情提示:(无需注册或充值,赞助后即可获取资源下载链接)

     嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300

本次赞助数额为: 2 元 
   源码介绍


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");
    }
}