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.
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.
The width needed for the column to display all of its contents. The value is the same units as used for the width property.
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.
The width needed for the column to display the contents of the rows in the specified range. The value is the same units as used for the width property.
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.
A format object describing the actual formatting that will be used when displayed the row or column in Microsoft Excel.
InvalidOperationException If the object was removed from the worksheet.
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 column width in the specified units, or NaN if the column has the default width.
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.