ColumnCollection Class

Collects the objects that represent the individual columns in a worksheet.
Inheritance Hierarchy

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: (20.1)
public class ColumnCollection : CollectionBase

The ColumnCollection type exposes the following members.

Public propertyCapacity (Inherited from CollectionBase.)
Public propertyCount (Inherited from CollectionBase.)
Protected propertyInnerList (Inherited from CollectionBase.)
Public propertyItem
Gets a object by column index. The Column object of given column index will be instantiated if it does not exist before.
Protected propertyList (Inherited from CollectionBase.)
Public methodClear (Inherited from CollectionBase.)
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetByIndex Obsolete.
Gets the column object by the index.
Public methodGetColumnByIndex
Gets the Column object by the position in the list.
Public methodGetEnumerator (Inherited from CollectionBase.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Protected methodOnClear (Inherited from CollectionBase.)
Protected methodOnClearComplete (Inherited from CollectionBase.)
Protected methodOnInsert (Inherited from CollectionBase.)
Protected methodOnInsertComplete (Inherited from CollectionBase.)
Protected methodOnRemove (Inherited from CollectionBase.)
Protected methodOnRemoveComplete (Inherited from CollectionBase.)
Protected methodOnSet (Inherited from CollectionBase.)
Protected methodOnSetComplete (Inherited from CollectionBase.)
Protected methodOnValidate (Inherited from CollectionBase.)
Public methodRemoveAt (Inherited from CollectionBase.)
Public methodToString (Inherited from Object.)

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Obtaining the reference of the first worksheet
Worksheet worksheet = workbook.Worksheets[0];

//Add new Style to Workbook
Style style = workbook.CreateStyle();

//Setting the background color to Blue
style.ForegroundColor = Color.Blue;

//setting Background Pattern
style.Pattern = BackgroundType.Solid;

//New Style Flag
StyleFlag styleFlag = new StyleFlag();

//Set All Styles
styleFlag.All = true;

//Change the default width of first ten columns
for (int i = 0; i < 10; i++)
    worksheet.Cells.Columns[i].Width = 20;

//Get the Column with non default formatting
ColumnCollection columns = worksheet.Cells.Columns;

foreach (Column column in columns)
    //Apply Style to first ten Columns
    column.ApplyStyle(style, styleFlag);

//Saving the Excel file


'Instantiating a Workbook object
Dim workbook As New Workbook()

'Obtaining the reference of the first worksheet
Dim worksheet As Worksheet = workbook.Worksheets(0)

'Add new Style to Workbook
Dim style As Style = workbook.CreateStyles()

'Setting the background color to Blue
style.ForegroundColor = Color.Blue

'setting Background Pattern
style.Pattern = BackgroundType.Solid

'New Style Flag
Dim styleFlag As New StyleFlag()

'Set All Styles
styleFlag.All = True

'Change the default width of first ten columns
For i As Integer = 0 To 9
    worksheet.Cells.Columns(i).Width = 20
Next i

'Get the Column with non default formatting
Dim columns As ColumnCollection = worksheet.Cells.Columns

For Each column As Column In columns
    'Apply Style to first ten Columns
    column.ApplyStyle(style, styleFlag)
Next column

'Saving the Excel file
See Also