Static
$tStatic
nextGets the default cell format for cells in this row or column.
Any default properties of the cell's format will take their value from this format when getting a resolved format.
The default cell format for cells in this row or column.Gets or sets the value indicating whether the row or column is hidden. The Hidden state also controls the expanded state of rows or columns in outline groups. Basically, an outline group simply provides an easy way to hide and unhide all rows or columns in the group at the same time, via the expansion indicator. The value indicating whether the row or column is hidden.
[[InvalidOperationException]] From the stter if the object was removed from the worksheet.
Gets the 0-based index of the column in the worksheet. The 0-based index of the column in the worksheet.
Gets or sets the outline level for the row or column.
Microsoft Excel supports hierarchical grouping of rows and columns with a maximum of seven levels of hierarchy. To create a group, set adjacent rows or columns to same outline level. When rows or columns are grouped, an outline indicator will provide a visual representation of the outline level. In addition, an outline group has an expansion indicator at one end of the group, which allows the user to easily hide and unhide all rows or column in the group with a single click.
The outline level for the row or column.[[ArgumentOutOfRangeException]] The value assigned is outside the valid outline level range of 0 and 7.
[[InvalidOperationException]] From the stter if the object was removed from the worksheet.
[[hidden]]
Gets or sets the column width including padding, in 256ths of the '0' digit character width in the workbook's default font.
If the width of the column is less than zero, the [[Worksheet.defaultColumnWidth]] of the owning worksheet will be used as the column's width.
The value assigned must be between -1 and 65535. Invalid values will be automatically adjusted to valid values.
Setting or getting this property is equivalent to calling [[setWidth]] or [[getWidth]] using the [[WorksheetColumnWidthUnit]] value of Character256th.
The column width including padding, in 256ths of the '0' digit character width in the workbook's default font.[[InvalidOperationException]] From the setter if the column was removed from the worksheet.
Sets the [[width]] to the extent required to display the contents of this column.
[[InvalidOperationException]] The column is not associated with a [[Worksheet]] such as when the column has been deleted or the Worksheet is not associated with a [[Workbook]] such as when the Worksheet has been deleted.
Sets the width to the extent required to display all of the contents for the specified range of rows.
[[InvalidOperationException]] The column is not associated with a [[Worksheet]] such as when the column has been deleted or the Worksheet is not associated with a [[Workbook]] such as when the Worksheet has been deleted.
[[ArgumentOutOfRangeException]] The 'startRowIndex' must be greater than or equal to 0, less than or equal to the 'endRowIndex' and less than or equal to the Count of the Rows in the Worksheet. Similarly the 'endRowIndex' must be greater than or equal to the 'startRowIndex' and less than the [[WorksheetRowCollection.maxCount]] of the Worksheet's [[Worksheet.rows]] collection which depends upon the [[Workbook.currentFormat]]
A 0-based index of the first row whose contents are to be calculated
A 0-based index of the last row whose contents are to be calculated
Returns the width required for the column to display all of its contents.
[[InvalidOperationException]] The column is not associated with a [[Worksheet]] such as when the column has been deleted or the Worksheet is not associated with a [[Workbook]] such as when the Worksheet has been deleted.
Returns the width required for the column to display all of the contents for the specified range of rows.
[[InvalidOperationException]] The column is not associated with a [[Worksheet]] such as when the column has been deleted or the Worksheet is not associated with a [[Workbook]] such as when the Worksheet has been deleted.
[[ArgumentOutOfRangeException]] The 'startRowIndex' must be greater than or equal to 0, less than or equal to the 'endRowIndex' and less than or equal to the Count of the Rows in the Worksheet. Similarly the 'endRowIndex' must be greater than or equal to the 'startRowIndex' and less than the [[WorksheetRowCollection.maxCount]] of the Worksheet's [[Worksheet.rows]] collection which depends upon the [[Workbook.currentFormat]]
A 0-based index of the first row whose contents are to be calculated
A 0-based index of the last row whose contents are to be calculated
Gets the resolved cell formatting for the cells in the row or column.
[[InvalidOperationException]] If the object was removed from the worksheet.
[[cellFormat]]
Gets the column width in the specified units, or NaN if the column has the default width.
If 'units' is Character256th, the value returned will be the same as the value of the [[width]] property, with one exception: if the column has the default width, this method will return NaN and Width will return -1.
[[InvalidEnumArgumentException]] 'units' is not defined in the [[WorksheetColumnWidthUnit]] enumeration.
The units in which the width should be returned.
Sets the column width in the specified units.
Setting a value of NaN will reset the column width so that the column uses the default column width of the worksheet.
[[ArgumentException]] 'value' is infinity.
[[InvalidEnumArgumentException]] 'units' is not defined in the [[WorksheetColumnWidthUnit]] enumeration.
[[InvalidOperationException]] If the column was removed from the worksheet.
The width to set on the column, expressed in the specified 'units'.
The units in which the 'value' is expressed.
Static
compareStatic
compareStatic
equalsStatic
equalsStatic
getStatic
getStatic
getStatic
reference
Represents a column in a Microsoft Excel worksheet.