Column Methods
A single column in a worksheet.Name | Description |
---|---|
Auto |
Adjusts the column width to accommodate cell content. |
Begin |
Locks the Formatting object. Prevents visual updates until the End method calls.
Inherited from Formatting. |
Begin |
Starts modifying the cell range formatting.
Inherited from Cell |
Calculate() |
Forces recalculation of the current cell range.
Inherited from Cell |
Contains |
Determines whether the current cell range contains the specified range.
Inherited from Cell |
Copy |
Copies the source range of cells and pastes the specified part of the copied data into the current cell range.
Inherited from Cell |
Copy |
Copies the source range of cells and pastes the specified part of the copied data into the current cell range.
Inherited from Cell |
Copy |
Copies the specified range of cells into the current range.
Inherited from Cell |
Delete() | Deletes a column from a worksheet. |
End |
Unlocks the Formatting object after you call Begin . It also causes an immediate visual update.
Inherited from Formatting. |
End |
Finalizes the modification of the cell range formatting after calling the Cell |
Equals |
Determines whether or not the specified object is equal to the current Formatting instance. Inherited from Formatting. |
Exclude |
Excludes the specified cell or cell range from the current range.
Inherited from Cell |
Get |
Creates the data source from the current cell range.
Inherited from Cell |
Get |
Creates the data source from the current cell range using the specified options.
Inherited from Cell |
Get |
Returns a defined name associated with the current range.
Inherited from Cell |
Get |
Returns a defined name declared in the specified scope and associated with the current cell range.
Inherited from Cell |
Get |
Returns an enumerator that iterates through the collection.
Inherited from IEnumerable |
Get |
Returns merged ranges intersecting the current cell range.
Inherited from Cell |
Get |
Returns the cell range that covers the current range and does not contain the intersecting ranges.
Inherited from Cell |
Get |
Returns the copy of the source range with its reference replaced by the absolute reference.
Inherited from Cell |
Get |
Returns the copy of the source range with its reference replaced by the relative reference.
Inherited from Cell |
Get |
Gets the relative cell or cell range reference in the A1 reference style.
Inherited from Cell |
Get |
Gets the cell or cell range reference in the A1 reference style.
Inherited from Cell |
Get |
Gets the relative cell or cell range reference in the R1C1 reference style.
Inherited from Cell |
Get |
Gets the cell or cell range reference in the R1C1 reference style.
Inherited from Cell |
Get |
Gets the rich text string contained in a cell.
Inherited from Cell |
Insert() | Inserts a new column into the worksheet. |
Intersect |
Returns the cell range that is the intersection of the current and specified ranges.
Inherited from Cell |
Is |
Determines whether the current range intersects with the specified range.
Inherited from Cell |
Move |
Moves a range to a specified location.
Inherited from Cell |
Offset |
Returns a cell range that is a given number of rows and columns from the current range.
Inherited from Cell |
Resize |
Resizes the current cell range.
Inherited from Cell |
Search |
Performs a search in the cell range using specified options.
Inherited from Cell |
Search |
Performs a search in the cell range using the default parameters.
Inherited from Cell |
Set |
Sets all inside borders of the cell range.
Inherited from Cell |
Set |
Assigns the rich formatted text to a cell.
Inherited from Cell |
Set |
Converts the specified object to the cell value.
Inherited from Cell |
Set |
Parses the supplied string and creates a cell value to assign it to the cells in the current range.
Inherited from Cell |
Set |
Parses the supplied string and creates a cell value to assign it to the cells in the current range.
Inherited from Cell |
Union |
Creates a complex range that is the union of multiple ranges.
Inherited from Cell |
See Also