using?System;
using?System.Collections.Generic;
using?System.Diagnostics;
using?System.IO;
using?Microsoft.AspNetCore.Hosting;
using?Microsoft.AspNetCore.Http;
using?NPOI.HSSF.UserModel;
using?NPOI.HSSF.Util;
using?NPOI.SS.UserModel;
using?NPOI.SS.Util;
using?YY_Dal;
using?YY_Model;
using?YY_Utility;

namespace?YY_Services
{
????///?

????///?Excel文檔生成并保存和Excel文檔中的數據批量導出操作類
????///?

????public?class?NpoiExcelOperationService
????{
????????private?static?IHostingEnvironment?_environment;

????????private?readonly?SchoolUserInfoContext?_shoSchoolUserInfoContext;

????????public?NpoiExcelOperationService（SchoolUserInfoContext?schoolUserInfoContext?IHostingEnvironment?iEnvironment）
????????{
????????????_shoSchoolUserInfoContext?=?schoolUserInfoContext;
????????????_environment?=?iEnvironment;
????????}

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

????????///?Excel數據導出簡單示例
????????///?

????????///?導出結果
????????///?保存excel文件路徑
????????///?
????????public?bool?ExcelDataExport（out?string?resultMsg?out?string?excelFilePath）
????????{
????????????var?result?=?true;
????????????excelFilePath?=?““;
????????????resultMsg?=?“successfully“;
????????????//Excel導出名稱
????????????string?excelName?=?“人才培訓課程表“;
????????????try
????????????{
????????????????//首先創建Excel文件對象
????????????????var?workbook?=?new?HSSFWorkbook（）;

????????????????//創建工作表，也就是Excel中的sheet，給工作表賦一個名稱（Excel底部名稱）
????????????????var?sheet?=?workbook.CreateSheet（“人才培訓課程表“）;

????????????????//sheet.DefaultColumnWidth?=?20;//默認列寬

????????????????sheet.ForceFormulaRecalculation?=?true;//TODO:是否開始Excel導出后公式仍然有效（非必須）

????????????????#region?table?表格內容設置

????????????????#region?標題樣式

????????????????//設置頂部大標題樣式
????????????????var?cellstyleFont?=?NpoiExcelExportHelper._.Createstyle（workbook?HorizontalAlignment.Center?VerticalAlignment.Center?20?true?700?“楷體“?true?false?false?true?FillPattern.SolidForeground?HSSFColor.Coral.Index?HSSFColor.White.Index
????????????????????FontUnderlineType.None?FontSuperscript.None?false）;

????????????????//第一行表單
????????????????var?row?=?NpoiExcelExportHelper._.CreateRow（sheet?0?28）;

????????????????var?cell?=?row.CreateCell（0）;
????????????????//合并單元格?例：?第1行到第2行?第3列到第4列圍成的矩形區域

????????????????//TODO:關于Excel行列單元格合并問題
????????????????/**
??????????????????第一個參數：從第幾行開始合并
??????????????????第二個參數：到第幾行結束合并
??????????????????第三個參數：從第幾列開始合并
??????????????????第四個參數：到第幾列結束合并
????????????????**/
????????????????CellRangeAddress?region?=?new?CellRangeAddress（0?0?0?5）;
????????????????sheet.AddMergedRegion（region）;

????????????????cell.SetCellValue（“人才培訓課程表“）;//合并單元格后，只需對第一個位置賦值即可（TODO:頂部標題）
????????????????cell.Cellstyle?=?cellstyleFont;

????????????????//二級標題列樣式設置
????????????????var?headTopstyle?=?NpoiExcelExportHelper._.Createstyle（workbook?HorizontalAlignment.Center?Ver

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

?????文件?????????16??2020-09-08?00:10??NPOI-ExportWordAndExcel-ImportExcelData\.git\COMMIT_EDITMSG

?????文件????????423??2020-08-28?02:28??NPOI-ExportWordAndExcel-ImportExcelData\.git\config

?????文件?????????73??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\description

?????文件????????278??2020-09-08?00:10??NPOI-ExportWordAndExcel-ImportExcelData\.git\FETCH_HEAD

?????文件?????????23??2020-09-08?00:11??NPOI-ExportWordAndExcel-ImportExcelData\.git\HEAD

?????文件????????478??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\applypatch-msg.sample

?????文件????????896??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\commit-msg.sample

?????文件???????3327??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\fsmonitor-watchman.sample

?????文件????????189??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\post-update.sample

?????文件????????424??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\pre-applypatch.sample

?????文件???????1638??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\pre-commit.sample

?????文件???????1348??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\pre-push.sample

?????文件???????4898??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\pre-rebase.sample

?????文件????????544??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\pre-receive.sample

?????文件???????1492??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\prepare-commit-msg.sample

?????文件???????3610??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\hooks\update.sample

?????文件??????32431??2020-09-08?00:11??NPOI-ExportWordAndExcel-ImportExcelData\.git\index

?????文件????????240??2020-08-25?23:56??NPOI-ExportWordAndExcel-ImportExcelData\.git\info\exclude

?????文件???????1314??2020-09-08?00:11??NPOI-ExportWordAndExcel-ImportExcelData\.git\logs\HEAD

?????文件????????728??2020-09-08?00:10??NPOI-ExportWordAndExcel-ImportExcelData\.git\logs\refs\heads\develop-.NetCore3.1

?????文件????????217??2020-08-26?00:06??NPOI-ExportWordAndExcel-ImportExcelData\.git\logs\refs\heads\master

?????文件????????294??2020-09-08?00:10??NPOI-ExportWordAndExcel-ImportExcelData\.git\logs\refs\remotes\origin\develop-.NetCore3.1

?????文件????????217??2020-08-26?00:06??NPOI-ExportWordAndExcel-ImportExcelData\.git\logs\refs\remotes\origin\HEAD

?????文件????????147??2020-09-08?00:10??NPOI-ExportWordAndExcel-ImportExcelData\.git\ms-persist.xml

?????文件??????13559??2020-08-28?02:27??NPOI-ExportWordAndExcel-ImportExcelData\.git\objects\00\8cadd20ef1a917c0b064a76a37cf39deb84420

?????文件???????9914??2020-09-08?00:10??NPOI-ExportWordAndExcel-ImportExcelData\.git\objects\00\abe810812c13ed61b85e67dd2428acb4b713cb

?????文件??????30022??2020-08-28?02:28??NPOI-ExportWordAndExcel-ImportExcelData\.git\objects\00\b0754412231f804c690dfb44446954fed66130

?????文件??????10926??2020-09-08?00:10??NPOI-ExportWordAndExcel-ImportExcelData\.git\objects\01\ee061b501144a8ea197bf7302efc934b2a7f40

?????文件??????10409??2020-09-08?00:10??NPOI-ExportWordAndExcel-ImportExcelData\.git\objects\02\b08e17def0786314e1081272d4f10d1e93664f

?????文件??????24085??2020-09-08?00:10??NPOI-ExportWordAndExcel-ImportExcelData\.git\objects\02\eb9c0996eccab31fc30c8a9963ab0d95332527

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