using?System;
using?System.Collections;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Configuration;
using?System.Data;
using?NPOI.HSSF.UserModel;
using?System.IO;
using?System.Net.Http;
using?System.Net.Http.Headers;
using?NPOI.XSSF.UserModel;
using?NPOI.SS.UserModel;
using?NPOI.SS.Util;
//using?log4net;

namespace?Test.Models?{

????/*?
?????*?調(diào)用實例
?????*??Dictionary>?dicHeads?=?new?Dictionary>（）;
????????string?fileName?=?“調(diào)查_“?+?DateTime.Now.ToString（“yyyyMMdd_hhmmss“）?+?“.xls“;
????????DataSet?ds?=?new?DataSet（）;
????????DataTable?dt1?=?new?DataTable（“測試表格1“）;
????????ds.Tables.Add（dt1）;

????????List?heads?=?new?List（）;
????????heads.Add（new?NpoiHeadCfg（“測試表格1“?“rownumber“?“行號“?20?13））;
????????heads.Add（new?NpoiHeadCfg（“測試表格1“?“dateid“?“日期“?20?13））;

????????NpoiHeadCfg?hc3?=?new?NpoiHeadCfg（“測試表格1“?““?“10月1號“?20）;?
????????hc3.Childs.Add（new?NpoiHeadCfg（““?“day1_zb1“?“完工總數(shù)“））;
????????hc3.Childs.Add（new?NpoiHeadCfg（““?“day1_zb2“?“回復總數(shù)“））;
????????hc3.Childs.Add（new?NpoiHeadCfg（““?“day1_zb3“?“回復率“））;
????????//
????????dicHeads.Add（dt1.TableName?heads）;

????????NpoiExcelExport.ExporXSSFExcel（ds?dicHeads?fileName）;
?????*?*/

????///?

????///??NPOI導出真正的電子表格，支持?自定義多行表頭（表頭風格設(shè)置），支持多個sheet頁面導出?
????///?

????///?
????///?創(chuàng)建：shunlu?2018-10-24?
????///?
????public?class?NpoiExcelExport?{

????????//?static?ILog?log?=?LogManager.GetLogger（typeof（NpoiExcelExport））;

???????
????????///?

????????///?導出真正的電子表格
????????///?

????????///?數(shù)據(jù)源
????????///?表頭設(shè)置列表
????????///?文件名稱
????????///?是否從網(wǎng)絡(luò)下載?true?下載，false?不下載
????????///?保存到本地路徑（不含文件名稱），savePath為空不保存本地文件
????????///?
????????///?創(chuàng)建：shunlu?2018-10-24?
????????///?
????????public?static?dynamic?ExporXSSFExcel（DataSet?ds?Dictionary>?heads?string?fileName?bool?downLoad?=?true?string?savePath?=?““）?{
????????????//創(chuàng)建?電子表格文件
????????????XSSFWorkbook?book?=?new?XSSFWorkbook（）;

????????????try?{
????????????????for?（int?i?=?0;?i?
????????????????????//?log.Debug（“ExporXSSFExcel?“?+?i?+?“:表名：“?+?ds.Tables[i].TableName）;

????????????????????if?（heads.ContainsKey（ds.Tables[i].TableName））?{
????????????????????????//
????????????????????????var?_heads?=?heads[ds.Tables[i].TableName];
????????????????????????//
????????????????????????CreateSheet（book?i?ds.Tables[i]?_heads）;
????????????????????}
????????????????}
????????????????//保存文件
????????????????if?（!string.IsNullOrEmpty（savePath））?{
????????????????????SaveExcel（book?fileName?savePath）;
????????????????}
????????????????//?
????????????????//?服務(wù)端下載文件
???????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????187??2018-10-24?11:06??通用導出電子表格\App.config

?????文件?????200704??2011-01-03?14:16??通用導出電子表格\bin\Debug\ICSharpCode.SharpZipLib.dll

?????文件????1679360??2017-03-21?07:53??通用導出電子表格\bin\Debug\NPOI.dll

?????文件?????536064??2017-03-21?07:53??通用導出電子表格\bin\Debug\NPOI.OOxml.dll

?????文件??????91136??2017-03-21?07:53??通用導出電子表格\bin\Debug\NPOI.Openxml4Net.dll

?????文件????2121728??2017-03-21?07:53??通用導出電子表格\bin\Debug\NPOI.OpenxmlFormats.dll

?????文件????2254144??2017-03-21?07:53??通用導出電子表格\bin\Debug\NPOI.xml

?????文件??????17408??2018-10-28?23:49??通用導出電子表格\bin\Debug\通用導出電子表格.exe

?????文件????????187??2018-10-24?11:06??通用導出電子表格\bin\Debug\通用導出電子表格.exe.config

?????文件??????29088??2018-10-28?23:46??通用導出電子表格\NpoiExcelExport.cs

?????文件????????204??2018-10-24?11:08??通用導出電子表格\packages.config

?????文件???????5936??2018-10-28?23:50??通用導出電子表格\Program.cs

?????文件???????1374??2018-10-24?11:06??通用導出電子表格\Properties\AssemblyInfo.cs

?????文件???????4063??2018-10-27?23:26??通用導出電子表格\通用導出電子表格.csproj

?????文件????????228??2018-10-27?23:26??通用導出電子表格\通用導出電子表格.csproj.user

?????文件???????1039??2018-10-24?11:06??通用導出電子表格.sln

?????文件????1678336??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net20\NPOI.dll

?????文件?????494080??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net20\NPOI.OOxml.dll

?????文件??????91136??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net20\NPOI.Openxml4Net.dll

?????文件????2120192??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net20\NPOI.OpenxmlFormats.dll

?????文件????2254144??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net20\NPOI.xml

?????文件????1679360??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net40\NPOI.dll

?????文件?????536064??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net40\NPOI.OOxml.dll

?????文件??????91136??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net40\NPOI.Openxml4Net.dll

?????文件????2121728??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net40\NPOI.OpenxmlFormats.dll

?????文件????2254144??2017-03-21?07:53??packages\NPOI.2.3.0\lib\net40\NPOI.xml

?????文件???????9851??2017-03-21?07:53??packages\NPOI.2.3.0\LICENSE

?????文件???????8143??2017-03-21?07:53??packages\NPOI.2.3.0\logo\120_120.jpg

?????文件??????15405??2017-03-21?07:53??packages\NPOI.2.3.0\logo\240_240.png

?????文件???????1835??2017-03-21?07:53??packages\NPOI.2.3.0\logo\32_32.jpg

............此處省略28個文件信息