CloseXML导出Excel文件

CloseXML是一款非常优秀的Excel工具类， 比NPOI简洁好用。 

源码与 dll 下载地址：点击打开链接

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

/*
注意：必须引用 
1. CloseXML.dll;
2. DocumentFormat.OpenXml.dll
 */
namespace CloseXMLTest
{
    class Program
    {
        static void Main(string[] args)
        {
            DataTable dt = GetDataTable();
            dt.TableName = "Sheet1";        //注意：必须有名字

            string filePath = "d:\\1.xlsx";
            var wb = new ClosedXML.Excel.XLWorkbook();
            wb.Worksheets.Add(dt);
            wb.SaveAs(filePath);

            Console.WriteLine("End");
            Console.Read();
        }

        /// <summary>
        /// 构建 DataTable ， 作为数据源
        /// </summary>
        /// <returns></returns>
        static DataTable GetDataTable() 
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("id",typeof(int)));
            dt.Columns.Add(new DataColumn("name", typeof(string)));

            for(int i=1;i<=10;i++)
            {
                DataRow dr = dt.NewRow();
                dr["id"] = i;
                dr["name"] = "name" + i.ToString();
                dt.Rows.Add(dr);
            }
            return dt;
        }
    }
}