ig.excel.WorksheetTableStyleArea
Remarks
Note: Only certain properties can be set on the table style are formats. The are as follows:
Setting any other format or font properties on the table style areas will cause an exception.
Dependencies
-
alternateColumnStripe
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 8
The format is applied to the even numbered column stripes in the table.
-
alternateRowStripe
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 6
The format is applied to the even numbered row stripes in the table.
-
columnStripe
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 7
The format is applied to the odd numbered column stripes in the table.
-
firstColumn
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 3
The format is applied to the first column in the table.
-
firstHeaderCell
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 9
The format is applied to the first header cell in the table.
-
firstTotalCell
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 11
The format is applied to the first total cell in the table.
-
headerRow
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 1
The format is applied to the header row in the table.
-
lastColumn
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 4
The format is applied to the last column in the table.
-
lastHeaderCell
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 10
The format is applied to the last header cell in the table.
-
lastTotalCell
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 12
The format is applied to the last total cell in the table.
-
rowStripe
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 5
The format is applied to the odd numbered row stripes in the table.
-
totalRow
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 2
The format is applied to the totals row in the table.
-
wholeTable
- Type:
- ig.excel.WorksheetTableStyleArea
- Default:
- 0
The format is applied to the entire table.