Creates a new instance of the Workbook class. Syntax Remarks The new workbook created is empty. At least one Worksheet must be added to it before it can be saved.
Creates a new instance of the Workbook class. Syntax Parameters format The file format to use when imposing format restrictions and saving. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException format is not defined in the WorkbookFormat enumeration. Remarks The new workbook created i...
Overload List
Represents one worksheet in a Microsoft Excel workbook. Syntax Remarks An Excel worksheet is essentially a table with a limited number of rows and columns. To create new worksheet, use WorksheetCollection.Add method of the Workbook.Worksheets collection on a Workbook instance.
Represents a cell in a Microsoft Excel worksheet. Syntax
A collection of cells in a row. Syntax Remarks Cells in this collection are lazily created (they are only created and added to the collection when they are accessed). If this collection is enumerated, it only enumerates the cells which were already accessed.
Public Properties
Public Properties
Gets the cell at the specified column index in the owning row. Syntax Parameters index The zero-based column index of the cell to get. Property Value The cell at the specified column index in the owning row. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than zero. System.Invalid...
Represents a comment for a cell. Syntax Remarks Comments cannot be added to a worksheets or a shape groups shapes collection. Instead, they must be set directly on the cell with the cells WorksheetCell.Comment property. It is not required that the anchors of this shape be initialized before setting it as the comme...