static void FormatTable(Workbook workbook) { #region #FormatTable Worksheet worksheet = workbook.Worksheets["FormatTable"]; workbook.Worksheets.ActiveWorksheet = worksheet; // Access a table. Table table = worksheet.Tables[0]; // Access the workbook's collection of table styles. TableStyleCollection tableStyles = workbook.TableStyles; // Access the built-in table style by its name. TableStyle tableStyle = tableStyles[BuiltInTableStyleId.TableStyleMedium16]; // Apply the style to the table. table.Style = tableStyle; // Show header and total rows. table.ShowHeaders = true; table.ShowTotals = true; // Enable banded column formatting for the table. table.ShowTableStyleRowStripes = false; table.ShowTableStyleColumnStripes = true; // Format the first column in the table. table.ShowTableStyleFirstColumn = true; worksheet.Visible = true; #endregion #FormatTable }
internal HtmlDocumentStyle(MainDocumentPart mainPart) { PrepareStyles(mainPart); tableStyle = new TableStyleCollection(this); runStyle = new RunStyleCollection(this); paraStyle = new ParagraphStyleCollection(this); this.QuoteCharacters = QuoteChars.IE; this.mainPart = mainPart; }
static void FormatTable(IWorkbook workbook) { #region #FormatTable Worksheet worksheet = workbook.Worksheets["FormatTable"]; workbook.Worksheets.ActiveWorksheet = worksheet; Table table = worksheet.Tables[0]; TableStyleCollection tableStyles = workbook.TableStyles; TableStyle tableStyle = tableStyles[BuiltInTableStyleId.TableStyleMedium21]; table.Style = tableStyle; table.ShowHeaders = true; table.ShowTotals = true; table.ShowTableStyleRowStripes = false; table.ShowTableStyleColumnStripes = true; table.ShowTableStyleFirstColumn = true; worksheet.Visible = true; #endregion #FormatTable }
void ApplyBuiltInTableStyle(IWorkbook workbook, Table table, string styleName) { // Access the workbook's collection of table styles. TableStyleCollection tableStyles = workbook.TableStyles; // Access the built-in table style from the collection by its name. TableStyle tableStyle = tableStyles[styleName]; // Apply the table style to the existing table. table.Style = tableStyle; // Show header and total rows. table.ShowHeaders = true; table.ShowTotals = true; // Apply banded column formatting to the table. table.ShowTableStyleRowStripes = false; table.ShowTableStyleColumnStripes = true; }
void ApplyInitialBuiltInTableStyle() { #region #ApplyInitialBuiltInTableStyle spreadsheetControl1.BeginUpdate(); // Access the workbook's collection of table styles. TableStyleCollection tableStyles = spreadsheetControl1.Document.TableStyles; // Access the built-in table style from the collection by its Id. TableStyle tableStyle = tableStyles[BuiltInTableStyleId.TableStyleDark9]; // Apply the table style to the existing table. Table myTable = spreadsheetControl1.ActiveWorksheet.Tables[0]; myTable.Style = tableStyle; // Show header and total rows. myTable.ShowHeaders = true; myTable.ShowTotals = true; // Apply banded column formatting to the table. myTable.ShowTableStyleRowStripes = false; myTable.ShowTableStyleColumnStripes = true; spreadsheetControl1.EndUpdate(); #endregion #ApplyInitialBuiltInTableStyle }