C#导出Excel（DataTable生成Excel）

使用C#利用Aspose.Cells.dll导出Excel. 优化了之前上传的导出Excel方法,希望能够对大家有帮助 大家也可以根据自己需求修改导出Excel方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Http;
using System.Web.Mvc;
using System.Web.Routing;

namespace ExportExcel.UI
{
    // Note: For instructions on enabling IIS6 or IIS7 classic mode 
    // visit http://go.microsoft.com/?linkId=9394801
    public class MvcApplication : System.Web.HttpApplication
    {
        protected void Application_Start（）
        {
            AreaRegistration.RegisterAllAreas（）;

            WebApiConfig.Register（GlobalConfiguration.Configuration）;
            FilterConfig.RegisterGlobalFilters（GlobalFilters.Filters）;
            RouteConfig.RegisterRoutes（RouteTable.Routes）;
        }
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件    6849024  2013-07-04 15:24  ExportExcel\Aspose.Cells.dll

     文件       1011  2016-09-11 17:40  ExportExcel\ExportExcel.sln

     文件        280  2016-09-11 17:40  ExportExcel\ExportExcel.UI\App_Start\FilterConfig.cs

     文件        605  2016-09-11 17:40  ExportExcel\ExportExcel.UI\App_Start\RouteConfig.cs

     文件        483  2016-09-11 17:40  ExportExcel\ExportExcel.UI\App_Start\WebApiConfig.cs

    .......   6849024  2013-07-04 15:24  ExportExcel\ExportExcel.UI\bin\Aspose.Cells.dll

     文件      11264  2016-09-12 12:43  ExportExcel\ExportExcel.UI\bin\ExportExcel.UI.dll

     文件       2289  2016-09-11 18:48  ExportExcel\ExportExcel.UI\bin\ExportExcel.UI.dll.config

     文件      30208  2016-09-12 12:43  ExportExcel\ExportExcel.UI\bin\ExportExcel.UI.pdb

    .......     45416  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\Microsoft.Web.Infrastructure.dll

    .......     23640  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\Microsoft.Web.Mvc.FixedDisplayModes.dll

    .......    391680  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\Newtonsoft.Json.dll

     文件     440219  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\Newtonsoft.Json.xml

    .......    180832  2012-07-10 21:52  ExportExcel\ExportExcel.UI\bin\System.Net.Http.dll

    .......    168520  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Net.Http.Formatting.dll

     文件     137872  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Net.Http.Formatting.xml

    .......     16480  2012-07-10 21:52  ExportExcel\ExportExcel.UI\bin\System.Net.Http.WebRequest.dll

     文件       5439  2012-06-29 01:00  ExportExcel\ExportExcel.UI\bin\System.Net.Http.WebRequest.xml

     文件     201824  2012-06-23 01:00  ExportExcel\ExportExcel.UI\bin\System.Net.Http.xml

    .......    138432  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Helpers.dll

     文件      74208  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Helpers.xml

    .......    323240  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Http.dll

    .......     73384  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Http.WebHost.dll

     文件      10071  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Http.WebHost.xml

     文件     379561  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Http.xml

    .......    507048  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Mvc.dll

     文件     847872  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Mvc.xml

    .......    266944  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Razor.dll

     文件     365160  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.Razor.xml

    .......     41152  2016-09-11 17:40  ExportExcel\ExportExcel.UI\bin\System.Web.WebPages.Deployment.dll

............此处省略144个文件信息