資源簡介
C#實現NPOI操作EXCEL
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?NPOI;
using?NPOI.HPSF;
using?NPOI.HSSF;
using?NPOI.HSSF.UserModel;
using?NPOI.POIFS;
using?NPOI.Util;
using?NPOI.HSSF.Util;
using?NPOI.HSSF.Extractor;
using?NPOI.SS.UserModel;
using?System.IO;
namespace?Use_NPOI
{
????class?Program
????{
????????static?void?Main(string[]?args)
????????{
????????????Console.WriteLine(“*******************開始生成Excel********************“);
????????????//使用NPOI開發包生成Excel
????????????HSSFWorkbook?workbook?=?new?HSSFWorkbook();//創建excel對象
????????????ICellstyle?cellstyle?=?workbook.CreateCellstyle();//這里是定義單元格樣式,注意:樣式要指定Workbook來創建的,類似于html中的css。
????????????cellstyle.FillPattern?=?FillPattern.SolidForeground;//設置樣式
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-12?17:06??Use_NPOI\
?????目錄???????????0??2017-07-12?17:06??Use_NPOI\Use_NPOI\
?????文件?????????189??2017-07-12?17:06??Use_NPOI\Use_NPOI\App.config
?????文件????????2283??2017-07-12?17:06??Use_NPOI\Use_NPOI\Program.cs
?????目錄???????????0??2017-07-12?17:06??Use_NPOI\Use_NPOI\Properties\
?????文件????????1324??2017-07-12?17:06??Use_NPOI\Use_NPOI\Properties\AssemblyInfo.cs
?????文件????????4223??2017-07-12?17:06??Use_NPOI\Use_NPOI\Use_NPOI.csproj
?????目錄???????????0??2017-07-12?17:06??Use_NPOI\Use_NPOI\bin\
?????目錄???????????0??2017-07-12?17:07??Use_NPOI\Use_NPOI\bin\Debug\
?????文件??????200704??2017-07-12?17:06??Use_NPOI\Use_NPOI\bin\Debug\ICSharpCode.SharpZipLib.dll
?????文件??????536064??2017-07-12?17:07??Use_NPOI\Use_NPOI\bin\Debug\NPOI.OOxm
?????文件???????91136??2017-07-12?17:06??Use_NPOI\Use_NPOI\bin\Debug\NPOI.Openxm
?????文件?????2121728??2017-07-12?17:07??Use_NPOI\Use_NPOI\bin\Debug\NPOI.Openxm
?????文件?????1679360??2017-07-12?17:07??Use_NPOI\Use_NPOI\bin\Debug\NPOI.dll
?????文件?????2254144??2017-07-12?17:07??Use_NPOI\Use_NPOI\bin\Debug\NPOI.xm
?????文件????????6144??2017-07-12?17:06??Use_NPOI\Use_NPOI\bin\Debug\Use_NPOI.exe
?????文件?????????189??2017-07-12?17:06??Use_NPOI\Use_NPOI\bin\Debug\Use_NPOI.exe.config
?????文件???????11776??2017-07-12?17:06??Use_NPOI\Use_NPOI\bin\Debug\Use_NPOI.pdb
?????文件???????22696??2017-07-12?17:06??Use_NPOI\Use_NPOI\bin\Debug\Use_NPOI.vshost.exe
?????文件?????????189??2017-07-12?17:06??Use_NPOI\Use_NPOI\bin\Debug\Use_NPOI.vshost.exe.config
?????文件?????????490??2017-07-12?17:06??Use_NPOI\Use_NPOI\bin\Debug\Use_NPOI.vshost.exe.manifest
?????目錄???????????0??2017-07-12?17:07??Use_NPOI\Use_NPOI\bin\Debug\files\
?????文件???????????3??2017-07-12?17:07??Use_NPOI\Use_NPOI\bin\Debug\files\test.txt
?????文件????????4608??2017-07-12?17:07??Use_NPOI\Use_NPOI\bin\Debug\files\testfile20170704095234.xls
?????目錄???????????0??2017-07-12?17:06??Use_NPOI\Use_NPOI\files\
?????文件???????????3??2017-07-12?17:06??Use_NPOI\Use_NPOI\files\test.txt
?????目錄???????????0??2017-07-12?17:06??Use_NPOI\Use_NPOI\obj\
?????目錄???????????0??2017-07-12?17:06??Use_NPOI\Use_NPOI\obj\Debug\
?????文件????????7299??2017-07-12?17:06??Use_NPOI\Use_NPOI\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????目錄???????????0??2017-07-12?17:08??Use_NPOI\Use_NPOI\obj\Debug\TempPE\
?????文件???????????0??2017-07-12?17:06??Use_NPOI\Use_NPOI\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
............此處省略42個文件信息
- 上一篇:c#注冊表管理工具 源碼
- 下一篇:C# Addin Vsto Excel小插件
評論
共有 條評論