Asp.net匯出到Excel

Asp.net匯出到Excel 的問題已經是老生常談了，今天忽然用到，感覺以前寫的有點亂，就順手封裝了一下，貼出代碼，僅供參考

 

using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Web;
using System.Data;

namespace AK.T.FileDeal
{
    public class Excel
    {

 　　 /// <summary>
        /// 匯出到Excel titile為excel的頭部，datatable欄位必須和title向對應
        /// </summary>
        /// <param name="ds"></param>
        /// <param name="title"></param>
        public void CreateExcel(DataTable ds, string[] title, System.Web.UI.Page page)
        {
            HttpResponse resp;
            resp = page.Response;
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=Cards_" + DateTime.Now.ToShortDateString() + ".xls");

            string ls_item = "";
            string colHeaders = "";
            DataTable dt = ds;
            DataRow[] myRow = dt.Select("");

            for (int i = 0; i < title.Length; i++)
            {
                if (i == title.Length - 1)
                {
                    colHeaders += title[i] + "\n";
                    continue;
                }
                colHeaders += title[i] + "\t";
            }

           int count = title.Length;

            foreach (DataRow row in myRow)
            {
                for (int i = 0; i < count; i++)
                {
                    if (i == count - 1)
                    {
                        ls_item += row[i].ToString() + "\n";
                        continue;
                    }
                    ls_item += row[i].ToString() + "\t";
                }
            }
            resp.Write(colHeaders + ls_item);
            resp.End();
        }

        /// <summary>
        ///  匯出到Excel titile為excel的頭部，DtRow為ds中欄位的名稱
        /// </summary>
        /// <param name="ds"></param>
        /// <param name="title"></param>
        /// <param name="DtRow"></param>
        public void CreateExcel(DataTable ds, string[] title, string[] DtRow, System.Web.UI.Page page)
        {
            if (DtRow.Length != ds.Rows.Count)
            {
                return;
            }
            HttpResponse resp;
            resp = page.Response;
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=Cards_" + DateTime.Now.ToShortDateString() + ".xls");

            string ls_item = "";
            string colHeaders = "";
            DataTable dt = ds;
            DataRow[] myRow = dt.Select("");

            for (int i = 0; i < title.Length; i++)
            {
                if (i == title.Length - 1)
                {
                    colHeaders += title[i] + "\n";
                    continue;
                }
                colHeaders += title[i] + "\t";
            }
            foreach (DataRow row in myRow)
            {
                for (int i = 0; i < DtRow.Length; i++)
                {
                    if (i == DtRow.Length - 1)
                    {
                        ls_item += row[DtRow[i]].ToString() + "\n";
                        continue;
                    }
                    ls_item += row[DtRow[i]].ToString() + "\t";
                }
            }
            resp.Write(colHeaders + ls_item);
            resp.End();
        }

        /// <summary>
        /// 單行資料匯出
        /// </summary>
        /// <param name="title"></param>
        /// <param name="Content"></param>
        public void CreateOnceExcel(string[] title, string[] Content, System.Web.UI.Page page)
        {
            HttpResponse resp;
            resp = page.Response;
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=Cards_" + DateTime.Now.ToShortDateString() + ".xls");

            string ls_item = "";
            string colHeaders = "";

            for (int i = 0; i < title.Length; i++)
            {
                if (i == title.Length - 1)
                {
                    colHeaders += title[i] + "\n";
                    continue;
                }
                colHeaders += title[i] + "\t";
            }
            for (int i = 0; i < Content.Length; i++)
            {
                if (i == Content.Length - 1)
                {
                    ls_item += Content[i].ToString() + "\n";
                    continue;
                }
                ls_item += Content[i].ToString() + "\t";
            }

            resp.Write(colHeaders + ls_item);
            resp.End();
        }

    }
}