MyNPOI/DownExcel.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

namespace MyNPOI
{
    public partial class DownExcel : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        // 下载于www.51aspx.com
        protected void btn_OutPortExcel_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            DataColumn col = new DataColumn("ID", System.Type.GetType("System.String"));
            DataColumn col1 = new DataColumn("姓名", System.Type.GetType("System.String"));
            DataColumn col2 = new DataColumn("邮箱", System.Type.GetType("System.String"));
            dt.Columns.Add(col);
            dt.Columns.Add(col1);
            dt.Columns.Add(col2);
            DataRow row = dt.NewRow();
            row[0] = "11";
            row[1] = "111";
            row[2] = "11@11.com";
            dt.Rows.Add(row);
            // 下载于www.51aspx.com
            System.Collections.SortedList List = new System.Collections.SortedList();
            List.Add(0, "ID");
            List.Add(1, "姓名");
            List.Add(2, "邮箱");

            ExcelHelper.ExportByWeb(dt, "excel导出","报表.xls");
        }
    }
}