Skip to main content
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.
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