ColumnCollection Methods
A collection of all columns in a worksheet.| Name | Description |
|---|---|
| AutoFit(Int32, Int32) | Adjusts the width of columns to accommodate cell content. |
| AutoFit(String, String) | Adjusts column widths to fit the cell content. |
| AutoOutline() | Automatically creates an outline for the specified columns. |
| ClearOutline() | Removes an outline of columns. |
| ClearOutline(Int32, Int32) | Clears an outline for the specified columns. |
| ClearOutline(String, String) | Clears an outline for the specified columns. |
| CollapseAllGroups() | Collapses all the column groups in a worksheet. |
| CollapseGroups(Int32) | Collapses all column groups starting from the specified level. |
| ExpandAllGroups() | Expands all the column groups in a worksheet. |
| Group(Int32, Int32, Boolean) | Groups the specified columns on a worksheet. |
| Group(String, String, Boolean) | Groups the specified columns on a worksheet. |
| Hide(Int32, Int32) | Hides the specified columns in a worksheet. |
| Hide(String, String) | Hides the specified columns in a worksheet. |
| Insert(Int32, Int32, ColumnFormatMode) | Inserts multiple columns and specifies how to format these columns. |
| Insert(Int32, Int32) | Inserts multiple columns into the worksheet. |
| Insert(Int32) | Inserts a new column into the worksheet at the specified position. |
| Insert(String, Int32, ColumnFormatMode) | Inserts multiple columns and specifies how to format these columns. |
| Insert(String, Int32) | Inserts multiple columns into the worksheet. |
| Insert(String) | Inserts a column with the specified heading into the worksheet. |
| Remove(Func<Int32, Boolean>) | Removes columns that match the specified condition from the worksheet. |
| Remove(Int32, Func<Int32, Boolean>) | Removes columns that match the specified condition from the worksheet. |
| Remove(Int32, Int32, Func<Int32, Boolean>) | Removes columns that match the specified condition from the worksheet. |
| Remove(Int32, Int32) | Removes multiple columns from a worksheet. |
| Remove(Int32) | Removes the column at the specified position from the worksheet. |
| Remove(String, String) | Removes multiple columns from a worksheet. |
| Remove(String) | Removes a column with the specified heading from the worksheet. |
| UnGroup(Int32, Int32, Boolean) | Ungroups the grouped columns on a worksheet. |
| UnGroup(String, String, Boolean) | Ungroups the grouped columns on a worksheet. |
| Unhide(Int32, Int32) | Displays the hidden columns on a worksheet. |
| Unhide(String, String) | Displays the hidden columns on a worksheet. |
See Also