Skip to main content
A newer version of this page is available. .
.NET Framework 4.5.2+
Row

ColumnCollection Members

A collection of all columns in a worksheet.

Properties

Name Description
Item[Int32] Provides indexed access to individual columns in the collection.
Item[String] Provides access to an individual column in the collection by its heading.
LastUsedIndex Gets the index of the last edited column on a worksheet.

Methods

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