Skip to main content
Row

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