.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
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) Inserts a new column into the worksheet at the specified position.
Insert(Int32, Int32) Inserts multiple columns into the worksheet.
Insert(Int32, Int32, ColumnFormatMode) Inserts multiple columns and specifies how to format these columns.
Insert(String) Inserts a column with the specified heading into the worksheet.
Insert(String, Int32) Inserts multiple columns into the worksheet.
Insert(String, Int32, ColumnFormatMode) Inserts multiple columns and specifies how to format these columns.
Remove(Func<Int32, Boolean>) Removes columns that match the specified condition from the worksheet.
Remove(Int32) Removes the column at the specified position from the worksheet.
Remove(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, Int32, Func<Int32, Boolean>) Removes columns that match the specified condition from the worksheet.
Remove(String) Removes a column with the specified heading from the worksheet.
Remove(String, String) Removes multiple columns from a 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