Hides the rows in the specified range. Syntax Parameters startIndex The index of the first row to hide, or null to start hiding at the first row.count The number of rows to hide. If null, a single row will be hidden when startIndex is specified and otherwise, all rows will be hidden. Exceptions Exception Descripti...
Gets the collection of hyperlinks applied to cells and regions in the Worksheet. Syntax
Gets or sets the background image for the worksheet. Syntax Property Value The background image for the worksheet. Remarks This image is tiled across the background of the worksheet. If null, the worksheet will have no background.
Gets the zero-based index of this worksheet in its parent Worksheets collection. Syntax Property Value The zero-based index of this worksheet in its parent Worksheets collection. Remarks Negative one indicates the worksheet has been removed from its parent collection.
Inserts a region of cells. Syntax Parameters address The region to insertshiftCellsRight If true will shift existing cells right to make room for the newly inserted cells, otherwise will shift existing cells down below the region. Exceptions Exception Description System.InvalidOperationException If the operation i...
Inserts a region of cells. Syntax Parameters region The region to insertshiftCellsRight If true will shift existing cells right to make room for the newly inserted cells, otherwise will shift existing cells down below the region. Exceptions Exception Description System.InvalidOperationException If the operation is...
Inserts a region of cells. Overload List
Returns a boolean indicating if the Worksheet has been protected. Syntax Remarks The IsProtected property will return true if the Worksheet is currently protected. When a Worksheet is protected only unprotected cells may be edited. In addition, other operations may be limited based on the properties of the Workshe...
Gets the collection of merged cell ranges in this worksheet. Syntax Property Value The collection of merged cell ranges in this worksheet. Remarks Use WorksheetMergedCellsRegionCollection.Add method to add new merged cell ranges to the worksheet.
Moves the worksheet to a new position in the owning workbooks collections of worksheets. Syntax Parameters index The new 0-based index to where the worksheet should be moved. Exceptions Exception Description System.InvalidOperationException The worksheet has previously been removed from its workbook. System.Argume...