Workbook Properties
Free Trial Web API version Licensing Request A Quote
HAVE QUESTIONS OR NEED HELP?SUBMIT THE SUPPORT REQUEST FORM or write email toSUPPORT@BYTESCOUT.COM
The Workbook type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | AddInFunctionsNamesLocale | Gets or sets the add in functions names locale. |
| AutoCalculation | Gets or sets a value indicating if formula should be re-calculated automatically on change of cells value. |
| Charts | Gets the charts. |
| Colors | Gets the colors in the user-defined palette. The palette has 56 entries. |
| DefaultFont | Gets or sets the workbook default font. |
| DocumentProperties | Document Properties |
| EncryptionKeyLength | Gets or sets value that specifies the number of bits in the encryption key. Must be a multiple of 8. |
| EncryptionType | Gets or sets the type of the encryption. |
| ExternalReferenceUpdate | Gets or sets a value indicating whether external reference should be updated or not. |
| Locale | Gets or sets the CultureInfo using in Workbook. This property should be used to set the locale (regional) settings for use in the new workbook (number, currency, time, date formatting). When you load existing spreadsheet then the SDK tries to use the saved locale settings for this file disregarding current Windows regional and language settings. When new workbook is created then the current Windows locale is used by default. |
| Names | Gets collection of the DefinedName objects. |
| Password | Sets the password to use for encryption file. |
| PictureList | |
| Properties | Workbook properties |
| ProtectStructure | Gets or sets a value indicating whether the order of the sheets in the workbook is protected. |
| ProtectWindows | Gets or sets a value indicating whether the windows of the workbook are protected. |
| RangeSelectionMethod | Gets or sets the range selection method. |
| ReadOnlyRecommended | Gets or sets a value indicating whether the workbook is read only recommended. |
| WorkbookView | |
| Worksheets | Gets the worksheets. |
See Also