/// <summary> /// Excel处理 /// </summary> /// <param name="excelGlobalDTO"></param> public void ExcelHandle(ExcelGlobalDTO <TEntity> excelGlobalDTO) { //执行处理前扩展 ExcelHandleBefore(excelGlobalDTO); //设置区块 AreaBlock <TEntity> areaBlock = new AreaBlock <TEntity>(); areaBlock.SetAreaBlock(excelGlobalDTO); //设置头部颜色 HeadColor <TEntity> headColor = new HeadColor <TEntity>(); headColor.SetHeadColor(excelGlobalDTO); excelGlobalDTO.PerformanceMonitoring.Start("SetRowColor"); //设置行颜色 RowColor <TEntity> rowColor = new RowColor <TEntity>(); rowColor.SetRowColor(excelGlobalDTO); excelGlobalDTO.PerformanceMonitoring.Stop(); //设置锁定 SheetLocked <TEntity> sheetLocked = new SheetLocked <TEntity>(); sheetLocked.SetSheetLocked(excelGlobalDTO); //设置列隐藏 SheetColumnHidden <TEntity> sheetColumnHidden = new SheetColumnHidden <TEntity>(); sheetColumnHidden.SetSheetColumnHidden(excelGlobalDTO); //批注 Comment <TEntity> comment = new Comment <TEntity>(); //清空批注 comment.ClearComment(excelGlobalDTO); //设置批注 comment.SetComment(excelGlobalDTO); //设置列类型 SheetColumnType <TEntity> sheetColumnType = new SheetColumnType <TEntity>(); sheetColumnType.SetSheetColumnType(excelGlobalDTO); //从Excel处理 SlaveExcel <TEntity> slaveExcel = new SlaveExcel <TEntity>(); slaveExcel.SlaveExcelHandle(excelGlobalDTO); //执行处理后扩展 ExcelHandleAfter(excelGlobalDTO); }