using?NPOI.HPSF;
using?NPOI.HSSF.UserModel;
using?NPOI.HSSF.Util;
using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.IO;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;

namespace?WindowsFormsApplication1
{
????class?Class1
????{

????????///?
???
????????///?DataTable導(dǎo)出到Excel的MemoryStream???
????????///?
???
????????///?源DataTable???
????????///?表頭文本???
????????public?static?MemoryStream?Export（DataTable?dtSource?string?strHeaderText）
????????{
????????????HSSFWorkbook?workbook?=?new?HSSFWorkbook（）;
????????????HSSFSheet?sheet?=?workbook.CreateSheet（“Sheet1“）;

????????????#region?右擊文件?屬性信息
????????????{
????????????????DocumentS

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

????..A..H.?????54784??2018-07-13?16:28??WindowsFormsApplication1\.vs\WindowsFormsApplication1\v14\.suo

?????文件????????189??2018-07-13?09:54??WindowsFormsApplication1\WindowsFormsApplication1\App.config

?????文件??????11264??2014-10-15?15:01??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\MyNPOI.dll

?????文件??????91648??2010-01-29?16:44??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\NPOI.DDF.dll

?????文件???????9728??2010-01-29?16:44??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\NPOI.dll

?????文件??????53248??2010-01-29?16:44??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\NPOI.HPSF.dll

?????文件?????921600??2010-01-29?16:44??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\NPOI.HSSF.dll

?????文件??????48640??2010-01-29?16:44??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\NPOI.POIFS.dll

?????文件??????33792??2010-01-29?16:44??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\NPOI.Util.dll

?????文件??????14848??2018-07-13?16:26??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe

?????文件????????189??2018-07-13?09:54??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe.config

?????文件??????26112??2018-07-13?16:26??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.pdb

?????文件??????22696??2018-07-13?16:27??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.vshost.exe

?????文件????????189??2018-07-13?09:54??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.vshost.exe.config

?????文件????????490??2017-09-29?21:43??WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.vshost.exe.manifest

?????文件??????10878??2018-07-13?16:25??WindowsFormsApplication1\WindowsFormsApplication1\Class1.cs

?????文件???????1885??2018-07-13?16:26??WindowsFormsApplication1\WindowsFormsApplication1\Form1.cs

?????文件???????3064??2018-07-13?16:26??WindowsFormsApplication1\WindowsFormsApplication1\Form1.Designer.cs

?????文件???????5817??2018-07-13?16:26??WindowsFormsApplication1\WindowsFormsApplication1\Form1.resx

?????文件???????1464??2018-07-13?16:21??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????7707??2018-07-13?10:17??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件??????????0??2018-07-13?09:54??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2018-07-13?09:54??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2018-07-13?09:54??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件???????1992??2018-07-13?16:27??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.csproj.FileListAbsolute.txt

?????文件???????1012??2018-07-13?16:26??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.csproj.GenerateResource.Cache

?????文件??????31419??2018-07-13?10:18??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.csprojResolveAssemblyReference.cache

?????文件??????14848??2018-07-13?16:26??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.exe

?????文件????????180??2018-07-13?16:26??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.Form1.resources

?????文件??????26112??2018-07-13?16:26??WindowsFormsApplication1\WindowsFormsApplication1\obj\Debug\WindowsFormsApplication1.pdb

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