static void DuplicateTableStyle(Workbook workbook)
        {
            #region #DuplicateTableStyle
            Worksheet worksheet = workbook.Worksheets["Duplicate Table Style"];
            workbook.Worksheets.ActiveWorksheet = worksheet;

            // Access table.
            Table table1 = worksheet.Tables[0];
            Table table2 = worksheet.Tables[1];

            // Obtain the built-in table style.
            TableStyle sourceTableStyle = workbook.TableStyles[BuiltInTableStyleId.TableStyleMedium17];

            // Duplicate the table style.
            TableStyle newTableStyle = sourceTableStyle.Duplicate();

            // Modify the duplicated table style's formatting.
            newTableStyle.TableStyleElements[TableStyleElementType.HeaderRow].Fill.BackgroundColor = Color.FromArgb(0xA7, 0xEA, 0x52);

            // Apply styles to tables.
            table1.Style = sourceTableStyle;
            table2.Style = newTableStyle;

            worksheet.Visible = true;
            #endregion #DuplicateTableStyle
        }
        TableStyle DuplicateAndModifyTableStyle(IWorkbook workbook, string sourceStyleName)
        {
            // Get the table style to be duplicated.
            TableStyle sourceTableStyle = workbook.TableStyles[sourceStyleName];

            // Duplicate the table style.
            TableStyle newTableStyle = sourceTableStyle.Duplicate();

            // Modify the required formatting characteristics of the created table style.
            // For example, remove exisitng formatting from the header row element.
            newTableStyle.TableStyleElements[TableStyleElementType.HeaderRow].Clear();

            return(newTableStyle);
        }
예제 #3
0
        static void DuplicateTableStyle(IWorkbook workbook)
        {
            #region #DuplicateTableStyle
            Worksheet worksheet = workbook.Worksheets["Duplicate Table Style"];
            workbook.Worksheets.ActiveWorksheet = worksheet;
            Table      table1           = worksheet.Tables[0];
            Table      table2           = worksheet.Tables[1];
            TableStyle sourceTableStyle = workbook.TableStyles[BuiltInTableStyleId.TableStyleMedium19];
            TableStyle newTableStyle    = sourceTableStyle.Duplicate();
            newTableStyle.TableStyleElements[TableStyleElementType.HeaderRow].Clear();

            table1.Style = sourceTableStyle;
            table2.Style = newTableStyle;

            worksheet.Visible = true;
            #endregion #DuplicateTableStyle
        }