Esempio n. 1
0
        private static void CreateDemoHeadersTableWithNetOffice(ref Worksheet WORK_SHEET)
        {
            var table = new TableHandlers.ExcelTableHandler.Table(new Logger(Utilities.Get_Full_Output_Path("NetExcel header_demo log")));

            //Setting global header style for text
            var HGeneral = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo3.GeneralHeaderFormat, 0);

            //Setting specific fill for different groups and total [using .Formatter priority 1, higher than HGeneral 0]
            var HCell = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo3.HeaderCell, 1);
            var HGr1  = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo3.HeaderGroup1Cell, 1);
            var HGr2  = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo3.HeaderGroup2Cell, 1);
            var HGr3  = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo3.HeaderGroup3Cell, 1);

            var Cell = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo3.StandartInlineCell, 0);

            table.addColumn("HD1", 0).addFormat(HGeneral).addFormat(HCell).addCellFormat(Cell); //.EnableAutoMergeSameValues().EnableAutoMergeNextEmptyValues().UseRowDataAsInfoBlockDelimeter();
            table.addColumn("HD2", 1).addFormat(HGeneral).addFormat(HCell).addCellFormat(Cell); //.EnableAutoMergeSameValues().EnableAutoMergeNextEmptyValues();
            table.addColumn("HD3", 2).addFormat(HGeneral).addFormat(HCell).addCellFormat(Cell); //.EnableAutoMergeSameValues().EnableAutoMergeNextEmptyValues();
            table.addColumn("HD4", 3).addFormat(HGeneral).addFormat(HCell).addCellFormat(Cell); //.EnableAutoMergeSameValues();

            table.addHeaderGroup("GR1", "HD1").addFormat(HGeneral).addFormat(HGr1);
            table.addHeaderGroup("GR2", "HD1", "HD3", "HD4").addFormat(HGeneral).addFormat(HGr2);
            table.addHeaderGroup("GR2.5", "HD3").addFormat(HGeneral).addFormat(HGr1);
            table.addHeaderGroup("GR3", "HD4").addFormat(HGeneral).addFormat(HGr3);

            var data = ReportData.LoadDataDemo3();

            WORK_SHEET.Cells[2, 2].Value    = "Headers have 5 settings accessed via TABLE().Settings";
            WORK_SHEET.Cells[3, 2].Value    = "Settings // FixFirstNColumns = [int amount] and FixHeaderRows = [bool]";
            WORK_SHEET.Cells[4, 2].Value    = "Those are used to freeze some of vertical or horizontal areas of worksheet";
            table.Settings.FixFirstNColumns = 1;
            table.Settings.FixHeaderRows    = true;
            table.Settings.UseSmartResetForFixedColsAndRows = true;
            table.SetPivot(new TableHandlers.ExcelTableHandler.Table.Pivot(6, 4));
            table.Draw(ref WORK_SHEET, ref data);

            table.Settings.BubbleColumnCaptions = true;
            WORK_SHEET.Cells[2, table.getRightBottomCorner().lcCol + 3].Value = "Settings // UseSmartResetForFixedColsAndRows = [bool] and BubbleColumnCaptions = [bool]";
            WORK_SHEET.Cells[3, table.getRightBottomCorner().lcCol + 3].Value = "SmartReset will cause the effect when only first drawn table freeze panes while single instance of ExcelTH is applied to draw";
            WORK_SHEET.Cells[4, table.getRightBottomCorner().lcCol + 3].Value = "BubbleColumnCaptions rules whether captions should be closer to the top or to the bottom of header's area";
            table.SetPivot(new TableHandlers.ExcelTableHandler.Table.Pivot(7, table.getRightBottomCorner().lcCol + 3));
            table.Draw(ref WORK_SHEET, ref data);

            table.Settings.DrawHeaders = false;
            WORK_SHEET.Cells[table.getRightBottomCorner().lcRow + 3, table.pivot.lcCol].Value = "Settings // DrawHeaders = [bool]";
            WORK_SHEET.Cells[table.getRightBottomCorner().lcRow + 4, table.pivot.lcCol].Value = "DrawHeaders is set to false if you want to hide all of the headers and header groups";
            WORK_SHEET.Cells[table.getRightBottomCorner().lcRow + 5, table.pivot.lcCol].Value = "That's it. Enjoy!";
            table.SetPivot(new TableHandlers.ExcelTableHandler.Table.Pivot(table.getRightBottomCorner().lcRow + 6, table.pivot.lcCol));
            table.Draw(ref WORK_SHEET, ref data);
        }
Esempio n. 2
0
        private static void CreateSCTableWithNetOffice(ref Worksheet WORK_SHEET)
        {
            var table = new TableHandlers.ExcelTableHandler.Table(new Logger(Utilities.Get_Full_Output_Path("NetExcel table_demo log")));

            //Set specific fill for headers [using .Formatter; priority 1 is higher than 0]
            var styleH = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo1.SCHeaderCell, 0);

            //Set specific fill for rows [using .Formatter; priority 1 is higher than 0]
            var styleC = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.StandartInlineCell, 0);
            var styleEmptyWeaponOutline = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo1.EmptyWeaponStyle, 1);

            //Some extra-feature that hopefully will be modified for good. It's usable for now, but lacks of modification-proof
            //Specific formats for the part of entire row -- goes AFTER all cells in specific row are formatted
            table.addRowFormat(styleEmptyWeaponOutline);

            //Link new columns to array of data by indexes [addColumn(TITLE, DATA_ARRAY_INDEX)], add styling
            table.addColumn("#num [SRC]", 10).addFormat(styleH)
            .addCellFormat(new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.StandartInlineCell, 0))
            .addCellFormat(new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.StandartInlineRecordNumberCell, 1));
            //  VS
            table.addColumn("[NextEmpty]", 10).addFormat(styleH)
            .addCellFormat(new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.StandartInlineCell, 0))
            .addCellFormat(new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.StandartInlineRecordNumberCell, 1))
            .EnableAutoMergeNextEmptyValues();
            //Enable merging modes for column:
            //    -treat next same values in data array column as one and merge them;
            //    -treat all next empty values that do follow after non-empty value in data array column as last non-empty value and merge them;
            //    -break ALL COLUMNS merging rules when value is changed [provides infoblocks of multirow data]
            table.addColumn("Info [SRC]", 14).addFormat(styleH).addCellFormat(styleC);
            table.addColumn("[MergeSame]", 14).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeSameValues();

            table.addColumn("Unit [SRC]", 0).addFormat(styleH).addCellFormat(styleC);
            table.addColumn("[NE + BlockDelimeter]", 0).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeNextEmptyValues().UseRowDataAsInfoBlockDelimeter();

            table.addColumn("Health Points", 1).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeSameValues().EnableAutoMergeNextEmptyValues();
            table.addColumn("Shield Points", 2).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeSameValues().EnableAutoMergeNextEmptyValues();
            table.addColumn("Description", 3).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeSameValues();
            table.addColumn("Damage", 4).addCellFormat(styleC).addFormat(styleH).EnableAutoMergeSameValues();
            table.addColumn("Range", 5).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeSameValues();
            table.addColumn("Cooldown", 6).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeSameValues();
            table.addColumn("Minerals", 7).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeSameValues().EnableAutoMergeNextEmptyValues();
            table.addColumn("Vespene", 8).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeSameValues().EnableAutoMergeNextEmptyValues();
            table.addColumn("Resources", 9).addFormat(styleH).addCellFormat(styleC).EnableAutoMergeSameValues().EnableAutoMergeNextEmptyValues();

            //Set specific fill for different groups [using .Formatter; priority 1 is higher than 0]
            var styleSVA = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo1.SurvivabilityGroupCell, 1);
            var stylePwr = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo1.PowerGroupCell, 1);
            var styleCst = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo1.CostGroupCell, 1);
            var styleSgh = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo1.StrengthGroupCell, 1);
            var styleGeneralHeaderGroup = new TableHandlers.ExcelTableHandler.Table.Formatter(CellFormatsExcel.Demo1.SCHeaderCell, 0);

            //Adding groups of headers
            table.addHeaderGroup("Strength", "Health Points", "Shield Points",
                                 "Description", "Damage", "Range", "Cooldown").addFormat(styleSgh).addFormat(styleGeneralHeaderGroup);
            table.addHeaderGroup("Survivability", "Health Points", "Shield Points").addFormat(styleSVA).addFormat(styleGeneralHeaderGroup);
            table.addHeaderGroup("Powers", "Description", "Damage", "Range", "Cooldown").addFormat(stylePwr).addFormat(styleGeneralHeaderGroup);
            table.addHeaderGroup("Cost", "Minerals", "Vespene", "Resources").addFormat(styleCst).addFormat(styleGeneralHeaderGroup);



            WORK_SHEET.Cells[2, 2].Value = "Row cells have 3 settings available that can be accessed either by methods or by settings of a specific column.";
            WORK_SHEET.Range(WORK_SHEET.Cells[2, 2], WORK_SHEET.Cells[2, 14]).Merge();
            WORK_SHEET.Cells[3, 2].Value = "Those are: AutoMergeSameValues = [bool]; AutoMergeNextEmptyValues = [bool]; IsBlockDelimeter = [bool]";
            WORK_SHEET.Range(WORK_SHEET.Cells[3, 2], WORK_SHEET.Cells[3, 14]).Merge();
            WORK_SHEET.Cells[4, 2].Value = "Purpose: to control merge of column's cells content.";
            WORK_SHEET.Range(WORK_SHEET.Cells[4, 2], WORK_SHEET.Cells[4, 14]).Merge();
            WORK_SHEET.Cells[6, 2].Value = "While AutoMergeSameValues and AutoMergeNextEmptyValues are obvious, IsBlockDelimeter is not.";
            WORK_SHEET.Range(WORK_SHEET.Cells[6, 2], WORK_SHEET.Cells[6, 14]).Merge();
            WORK_SHEET.Cells[7, 2].Value = "IsBlockDelimeter is used to prevent merging any cells in current row with a previous row that is logically related to another information group (keyValue=>data / Infoblock structure).";
            WORK_SHEET.Range(WORK_SHEET.Cells[7, 2], WORK_SHEET.Cells[7, 18]).Merge();
            WORK_SHEET.Cells[8, 2].Value = "For better understanding, see table below. It has columns with source data marked with [SRC] key and ongoing column with some setting is enabled.";
            WORK_SHEET.Range(WORK_SHEET.Cells[8, 2], WORK_SHEET.Cells[8, 14]).Merge();
            //Specifying margins: coordinates of the left upper row [new Pivot(RowNumber, ColNumber)]
            table.SetPivot(new TableHandlers.ExcelTableHandler.Table.Pivot(9, 2));

            var data = ReportData.LoadDataDemo1();

            table.Draw(ref WORK_SHEET, ref data);
        }