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