Gets the collection of shapes on the worksheet. Syntax Property Value The collection of shapes on the worksheet.
Exposes methods to identify a region in the worksheet and to apply sort criteria to that region. Syntax
Gets the collection of WorksheetTable instances, or regions formatted as tables, in the worksheet. Syntax
Unhides the columns in the specified range. Syntax Parameters startIndex The index of the first column to unhide, or null to start unhiding at the first column.count The number of columns to unhide. If null, a single column will be unhidden when startIndex is specified and otherwise, all columns will be unhidden. ...
Unhides the rows in the specified range. Syntax Parameters startIndex The index of the first row to unhide, or null to start unhiding at the first row.count The number of rows to unhide. If null, a single row will be unhidden when startIndex is specified and otherwise, all rows will be unhidden. Exceptions Excepti...
Removes the Worksheet protection. Syntax Remarks Note: If the HasProtectionPassword returns true and you only want to remove the protection if the correct password was provided then the Unprotect(String) should be used instead.
Attempts to use the specified password to remove the Worksheet protection currently in place. Syntax Parameters password The password to validate against the current Worksheet protection password Remarks Note: If the Worksheet is not currently protected (i.e. IsProtected returns false) the method will not do anyth...
Attempts to use the specified password to remove the Worksheet protection currently in place. Syntax Parameters password The password to validate against the current Worksheet protection password Remarks Note: If the Worksheet is not currently protected (i.e. IsProtected returns false) the method will not do anyth...
Attempts to use the specified password to remove the Worksheet protection currently in place. Overload List
Gets the Workbook that owns the worksheet. Syntax Property Value The Workbook that owns the worksheet.