예제 #1
0
        /// <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);
        }