Returns the number of rows that are supported by the specified format. Syntax Parameters format The format used by the workbook. Return Value The maximum number of rows supported by the format.
Gets the table with the specified name. Syntax Parameters name The name of the table to get. Return Value A WorksheetTable instance if a table exists with the specified name; Otherwise null. Remarks Table names are compared case-insensitively.
Returns the WorkbookFormat based on the file extension of the specified file. Syntax Parameters fileName The filename of an excel file. Return Value The workbook format based on the file extension of the file, or null if the correct format cannot be determined.
Gets the value indicating whether the Workbook has a file write protection password that will be used to protect saved files or streams. Syntax Remarks Workbook instances loaded from files or streams with a write protection password will initially have IsFileWriteProtected set to true. It is recommended that consu...
Gets the value indicating whether the Workbook has an open password and will therefore be encrypted on subsequent saves. Syntax Remarks Workbook instances loaded from encrypted files or streams will cache the password used to decrypt the document and reuse it on subsequent saves. Therefore, HasOpenPassword will in...
Returns a boolean indicating if the Workbook has been protected with a password. Syntax Remarks When protecting a Workbook, a password is optional. The HasProtectionPassword will return true if the Workbook is currently protected (see IsProtected) and a password was specified when it was protected. To protect a Wo...
Gets the value indicating whether the Workbook was loaded with file write protection and the correct password has not yet been provided to ValidateFileWriteProtectionPassword. Syntax Remarks Workbook instances loaded from files or streams with a write protection password will initially have IsFileWriteProtected se...
Returns a boolean indicating if the Workbook has been protected. Syntax Remarks The IsProtected property will return true if the Workbook is currently protected. When a Workbook is protected certain operations related to the Worksheets displayed or their order or the properties of the windows for the Workbook may ...
Gets a value indicating whether the specified function will be recognized and solved by Microsoft Excel when the workbook is saved out. Syntax Parameters functionName The case-insensitive name of the function. Return Value True if the function will be recognized in Microsoft Excel; False otherwise.
Determines whether the workbook in the specified stream is encrypted with an open password. Syntax Parameters stream The stream to check for encryption. Return Value True if the stream contains a workbook which is encrypted; False otherwise Exceptions Exception Description System.ArgumentNullException Occurs when ...