ColumnCollection Class |
Namespace: Aspose.Cells
The ColumnCollection type exposes the following members.
Name | Description | |
---|---|---|
![]() | Capacity | Gets or sets the number of elements that the CollectionBase can contain. (Inherited from CollectionBase.) |
![]() | Count | Gets the number of elements contained in the CollectionBase instance. This property cannot be overridden. (Inherited from CollectionBase.) |
![]() | InnerList | Gets an ArrayList containing the list of elements in the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | Item |
Gets a object by column index. The Column object of given column index will be instantiated if it does not exist before.
|
![]() | List | Gets an IList containing the list of elements in the CollectionBase instance. (Inherited from CollectionBase.) |
Name | Description | |
---|---|---|
![]() | Clear | Removes all objects from the CollectionBase instance. This method cannot be overridden. (Inherited from CollectionBase.) |
![]() | Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
![]() | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
![]() | GetByIndex | Obsolete.
Gets the column object by the index.
|
![]() | GetColumnByIndex |
Gets the Column object by the position in the list.
|
![]() | GetEnumerator | Returns an enumerator that iterates through the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
![]() | GetType | Gets the type of the current instance. (Inherited from Object.) |
![]() | MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() | OnClear | Performs additional custom processes when clearing the contents of the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | OnClearComplete | Performs additional custom processes after clearing the contents of the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | OnInsert | Performs additional custom processes before inserting a new element into the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | OnInsertComplete | Performs additional custom processes after inserting a new element into the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | OnRemove | Performs additional custom processes when removing an element from the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | OnRemoveComplete | Performs additional custom processes after removing an element from the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | OnSet | Performs additional custom processes before setting a value in the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | OnSetComplete | Performs additional custom processes after setting a value in the CollectionBase instance. (Inherited from CollectionBase.) |
![]() | OnValidate | Performs additional custom processes when validating a value. (Inherited from CollectionBase.) |
![]() | RemoveAt | Removes the element at the specified index of the CollectionBase instance. This method is not overridable. (Inherited from CollectionBase.) |
![]() | ToString | Returns a string that represents the current object. (Inherited from Object.) |
[C#] //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 workbook.Save("D:\\book1.xls"); [VB.NET] '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 workbook.Save("D:\book1.xls")