导出Excel

 
两种方法,自己取舍

using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
using System.Data;
namespace Common.BaseClass
{
    public class FileExport
    {
        #region 导出文件为 Excel文件 文本格式
        /// <summary>
        /// 导出文件为 Excel文件
        /// </summary>
        /// <param name="dt">数据集</param>
        /// <param name="FileName">导出文件名称</param>
        /// <param name="headers">列名</param>
        /// <param name="remark">备注</param>
        public void CreateExcel(DataTable dt, string FileName, string[] headers, string[] remark)
        {

            HttpResponse resp;
            resp = HttpContext.Current.Response;
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
            //标题                  内容
            string colHeaders = "", ls_item = "";
            int i = 0;

            DataRow[] myRow = dt.Select("");
            for (i = 0; i < remark.Length; i++)
            {
                colHeaders += remark[i] + "/n";
            }
            //取得数据表各列标题，各标题之间以/t分割，最后一个列标题后加回车符
            for (i = 0; i < headers.Length; i++)
            {
                colHeaders += headers[i] + "/t";
            }
            colHeaders += "/n";
            //向HTTP输出流中写入取得的数据信息
            resp.Write(colHeaders);
            //逐行处理数据  
            foreach (DataRow row in myRow)
            {
                //在当前行中，逐列获得数据，数据之间以/t分割，结束时加回车符/n
                for (i = 0; i < dt.Columns.Count; i++)
                {
                    ls_item += row[i].ToString() + "/t";
                    //当前行数据写入HTTP输出流，并且置空ls_item以便下行数据    
                }
                ls_item += "/n";
                resp.Write(ls_item);
                ls_item = "";
            }

            //写缓冲区中的数据到HTTP头文件中
            resp.End();
        }
        #endregion

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

/// <summary>
        /// 将Dataset中的表导出到Excel中
        /// </summary>
        /// <param name="source">源数据集</param>
        /// <param name="fileName">保存的文件名</param>
        /// <param name="title">标题</param>
        /// <param name="headers">列名</param>
        /// <param name="explain">文件生成说明</param>
        /// <param name="ps">注释</param>
        public static void ExportToExcel(DataTable source, string fileName, string[] headers, string title, string explain,string []ps)
        {
            HttpResponse resp;
            resp = HttpContext.Current.Response;
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + fileName);

            string startExcelXML = @"<?xml version=""1.0"" encoding=""utf-8""?>
    <Workbook xmlns=""urn:schemas-microsoft-com:office:spreadsheet""
        xmlns:o=""urn:schemas-microsoft-com:office:office""
        xmlns:x=""urn:schemas-  microsoft-com:office:excel""
        xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet"">
            <Styles>
            <Style ss:ID=""Default"" ss:Name=""Normal"">
                <Alignment ss:Horizontal=""Center"" ss:Vertical=""Center""/>
                <Font/>
                <Interior/>
                <NumberFormat/>
                <Protection/>
                </Style>
            <Style ss:ID=""BoldColumn"">
                <Borders>
                <Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                </Borders>
                <Font ss:FontName=""宋体"" ss:Bold=""1"" x:CharSet=""134"" ss:Size=""12"" />
                <Interior ss:Color=""#D2EAF6"" ss:Pattern=""Solid""/>
            </Style>
            <Style ss:ID=""StringLiteral"">
                <NumberFormat ss:Format=""@""/>
                <Borders>
                <Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                </Borders>
                <Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""12"" />
            </Style>
            <Style ss:ID=""Decimal"">
                <NumberFormat ss:Format=""0.00""/>
                <Borders>
                <Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                </Borders>
                <Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""12"" />
            </Style>
            <Style ss:ID=""Integer"">
                <NumberFormat ss:Format=""0""/>
                <Borders>
                <Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                </Borders>
                <Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""12"" />
            </Style>
            <Style ss:ID=""DateLiteral"">
                <NumberFormat ss:Format=""yyyy-MM-dd HH:mm;@""/>
                <Borders>
                <Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                </Borders>
                <Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""12"" />
            </Style>
            <Style ss:ID=""ps""><!--注释-->
                <Alignment ss:Horizontal=""Left"" ss:Vertical=""Center""/>
                <Font ss:FontName=""宋体"" x:CharSet=""134""/>
                <Interior ss:Color=""#FFFFCC"" ss:Pattern=""Solid""/>
            </Style>
            <Style ss:ID=""explain""><!--说明:数据跟据什么而来-->
                <Alignment ss:Horizontal=""Left"" ss:Vertical=""Center""/>
                <Borders>
                <Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                <Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                </Borders>
                <Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""12""/>
            </Style>
            <Style ss:ID=""Title""><!--大标题-->
                <Alignment ss:Horizontal=""Center"" ss:Vertical=""Center""/>
                <Borders>
                <Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
                </Borders>
                <Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""16"" ss:Bold=""1""/>
            </Style>
            </Styles>";
            string endExcelXML = "/r/n</Workbook>";

            int rowCount = 0;
            int sheetCount = 0;