Public Properties
Inserts one or more rows into the collection Syntax Parameters index the insertion pointcount The number of rows 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.IndexOutOfRangeException ...
Gets the row at the specified index. Syntax Parameters index The zero-based index of the row to get. Property Value The row at the specified index. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than zero. System.InvalidOperationException index is greater than or equal to Workboo...
Removes one or more rows from the collection Syntax Parameters index the index of the first row to remove pointcount The number of rows to remove Exceptions Exception Description System.InvalidOperationException If the operation is not allowed, e.g. if it the range intersects with a protected region. System.IndexO...
Public Properties Public Methods
Public Methods
Public Properties
Applies a formula to the cell at the specified column index. Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow.formula The formula to parse and apply to the cell.cellReferenceMode The mode used to interpret cell references in the formula. Exceptions Exception Description System.Ar...
Gets the collection of cells in the row. Syntax Property Value The collection of cells in the row. Remarks The collection of cells is a fixed length collection, with the maximum number of cells in the collection being Workbook.MaxExcelColumnCount or Workbook.MaxExcel2007ColumnCount, depending on the Workbook.Curre...
Gets the data table to which the cell at the specified index belongs. Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow. Return Value The data table to which the cell belongs or null if the cell does not belong to a data table. Exceptions Exception Description System.ArgumentOutOf...