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]]

Enumeration Members

AlternateColumnStripe: 8

The format is applied to the even numbered column stripes in the table.

AlternateRowStripe: 6

The format is applied to the even numbered row stripes in the table.

ColumnStripe: 7

The format is applied to the odd numbered column stripes in the table.

FirstColumn: 3

The format is applied to the first column in the table.

FirstHeaderCell: 9

The format is applied to the first header cell in the table.

FirstTotalCell: 11

The format is applied to the first total cell in the table.

HeaderRow: 1

The format is applied to the header row in the table.

LastColumn: 4

The format is applied to the last column in the table.

LastHeaderCell: 10

The format is applied to the last header cell in the table.

LastTotalCell: 12

The format is applied to the last total cell in the table.

RowStripe: 5

The format is applied to the odd numbered row stripes in the table.

TotalRow: 2

The format is applied to the totals row in the table.

WholeTable: 0

The format is applied to the entire table.