Enumeration WorksheetTableStyleArea
Enumeration Members
AlternateColumnStripe
AlternateColumnStripe: 8
AlternateRowStripe
AlternateRowStripe: 6
ColumnStripe
ColumnStripe: 7
FirstColumn
FirstColumn: 3
FirstHeaderCell
FirstHeaderCell: 9
FirstTotalCell
FirstTotalCell: 11
HeaderRow
HeaderRow: 1
LastColumn
LastColumn: 4
LastHeaderCell
LastHeaderCell: 10
LastTotalCell
LastTotalCell: 12
RowStripe
RowStripe: 5
TotalRow
TotalRow: 2
WholeTable
WholeTable: 0
Represents the various areas which can have a format applied at the table style level.
Note: Only certain properties can be set on the table style are formats. The are as follows:- IWorksheetCellFormat.bottomBorderColorInfo
- IWorksheetCellFormat.bottomBorderStyle
- IWorksheetCellFormat.fill
- IWorksheetCellFormat.leftBorderColorInfo
- IWorksheetCellFormat.leftBorderStyle
- IWorksheetCellFormat.rightBorderColorInfo
- IWorksheetCellFormat.rightBorderStyle
- IWorksheetCellFormat.topBorderColorInfo
- IWorksheetCellFormat.topBorderStyle
Font.Bold
Font.ColorInfo
Font.Italic
Font.Strikeout
Font.UnderlineStyle
Setting any other format or font properties on the table style areas will cause an exception.
See
WorksheetTableStyle.areaFormats