Column Methods
A single column in a worksheet.Name | Description |
---|---|
AutoFit() | Adjusts the column width to accommodate cell content. |
BeginUpdate() | Locks the Formatting object by preventing visual updates until the EndUpdate method is called. Inherited from Formatting. |
BeginUpdateFormatting() | Starts modifying the cell range formatting. Inherited from Range. |
Calculate() | Forces recalculation of the current cell range. Inherited from Range. |
CopyFrom(Range, PasteSpecial, Boolean) | Copies the source range of cells and pastes the specified part of the copied data into the current cell range. Inherited from Range. |
CopyFrom(Range, PasteSpecial) | Copies the source range of cells and pastes the specified part of the copied data into the current cell range. Inherited from Range. |
CopyFrom(Range) | Copies the specified range of cells into the current range. Inherited from Range. |
Delete() | Deletes a column from a worksheet. |
EndUpdate() | Unlocks the Formatting object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from Formatting. |
EndUpdateFormatting(Formatting) | Finalizes the modification of the cell range formatting after calling the Range.BeginUpdateFormatting method. Inherited from Range. |
Equals(Object) | Determines whether or not the specified object is equal to the current Formatting instance. Inherited from Formatting. |
Exclude(Range) | Excludes the specified cell or cell range from the current range. Inherited from Range. |
GetDataSource() | Creates the data source from the current cell range. Inherited from Range. |
GetDataSource(RangeDataSourceOptions) | Creates the data source from the current cell range using the specified options. Inherited from Range. |
GetDefinedName() | Returns a defined name associated with the current range. Inherited from Range. |
GetDefinedName(DefinedNameScope) | Returns a defined name declared in the specified scope and associated with the current cell range. Inherited from Range. |
GetEnumerator() | Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>. |
GetMergedRanges() | Returns merged ranges intersecting the current cell range. Inherited from Range. |
GetMinimumCover() | Returns the cell range that covers the current range and does not contain the intersecting ranges. Inherited from Range. |
GetRangeWithAbsoluteReference() | Returns the copy of the source range with its reference replaced by the absolute reference. Inherited from Range. |
GetRangeWithRelativeReference() | Returns the copy of the source range with its reference replaced by the relative reference. Inherited from Range. |
GetReferenceA1() | Gets the relative cell or cell range reference in the A1 reference style. Inherited from Range. |
GetReferenceA1(ReferenceElement) | Gets the cell or cell range reference in the A1 reference style. Inherited from Range. |
GetReferenceR1C1(Cell) | Gets the relative cell or cell range reference in the R1C1 reference style. Inherited from Range. |
GetReferenceR1C1(ReferenceElement, Cell) | Gets the cell or cell range reference in the R1C1 reference style. Inherited from Range. |
GetRichText() | Gets the rich text string contained in a cell. Inherited from Range. |
Insert() | Inserts a new column into the worksheet. |
Intersect(Range) | Returns the cell range that is the intersection of the current and specified ranges. Inherited from Range. |
IsIntersecting(Range) | Indicates whether the current range intersects with the specified range. Inherited from Range. |
MoveTo(Range) | Moves a range to a specified location. Inherited from Range. |
Offset(Int32, Int32) | Returns the cell range that is offset by the specified number of rows and columns from the current range. Inherited from Range. |
Search(String, SearchOptions) | Performs a search in the cell range using specified options. Inherited from Range. |
Search(String) | Performs a search in the cell range using the default parameters. Inherited from Range. |
SetInsideBorders(Color, BorderLineStyle) | Sets all inside borders of the cell range. Inherited from Range. |
SetRichText(RichTextString) | Assigns the rich formatted text to a cell. Inherited from Range. |
SetValue(Object) | Converts the specified object to the cell value. Inherited from Range. |
SetValueFromText(String, Boolean) | Parses the supplied string and creates a cell value to assign it to the cells in the current range. Inherited from Range. |
SetValueFromText(String) | Parses the supplied string and creates a cell value to assign it to the cells in the current range. Inherited from Range. |
Union(Range) | Creates a complex range that is the union of multiple ranges. Inherited from Range. |
See Also