Skip to main content
A newer version of this page is available. .
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.
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.
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.
Hide(Int32, Int32) Hides the specified columns in a worksheet.
Insert(Int32, Int32) Inserts multiple columns into the worksheet.
Insert(Int32) Inserts a new column into the worksheet at the specified position.
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.
UnGroup(Int32, Int32, Boolean) Ungroups the grouped columns on a worksheet.
Unhide(Int32, Int32) Displays the hidden columns on a worksheet.
See Also