Removes the worksheet at the specified index from the collection. Syntax Parameters index The index of the worksheet to remove from the collection. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than zero or index is greater than or equal to Count. Remarks If there are any NamedR...
Represents a column in a Microsoft Excel worksheet. Syntax
A collection of columns in a worksheet. Syntax Remarks Columns in this collection are lazily created (they are only created and added to the collection when they are accessed). Therefore, if this collection is enumerated, it only enumerates the columns which were already accessed.
Public Properties Public Methods
Public Methods
Public Properties
Inserts one or more columns into the collection Syntax Parameters index the insertion pointcount The number of columns to insert Exceptions Exception Description System.InvalidOperationException If the operation is not allowed, e.g. if it would cause data to be shifted off the worksheet. System.IndexOutOfRangeExce...
Gets the column at the specified index. Syntax Parameters index The zero-based index of the column to get. Property Value The column at the specified index. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than zero. System.InvalidOperationException index is greater than or equal t...
Removes one or more columns from the collection Syntax Parameters index the index of the first column to remove pointcount The number of columns to remove Exceptions Exception Description System.InvalidOperationException If the operation is not allowed, e.g. if it the range intersects with a protected region. Syst...
Represents the various units in which a column width can be represented. Syntax Members Member Description Character The column width is represented in units of the 0 digit character width, including column padding. The digit is measured with the default font for the workbook. The padding is a few pixels on either...