Enumeration WorksheetTableStyleArea

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.