Link Search Menu Expand Document

Workbook Properties

The Workbook type exposes the following members.

Properties
NameDescription
Public propertyAddInFunctionsNamesLocale
Gets or sets the add in functions names locale.
Public propertyAutoCalculation
Gets or sets a value indicating if formula should be re-calculated automatically on change of cells value.
Public propertyCharts
Gets the charts.
Public propertyColors
Gets the colors in the user-defined palette. The palette has 56 entries.
Public propertyDefaultFont
Gets or sets the workbook default font.
Public propertyDocumentProperties
Document Properties
Public propertyEncryptionKeyLength
Gets or sets value that specifies the number of bits in the encryption key. Must be a multiple of 8.
Public propertyEncryptionType
Gets or sets the type of the encryption.
Public propertyExternalReferenceUpdate
Gets or sets a value indicating whether external reference should be updated or not.
Public propertyLocale
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.
Public propertyNames
Gets collection of the DefinedName objects.
Public propertyPassword
Sets the password to use for encryption file.
Public propertyPictureList
Public propertyProperties
Workbook properties
Public propertyProtectStructure
Gets or sets a value indicating whether the order of the sheets in the workbook is protected.
Public propertyProtectWindows
Gets or sets a value indicating whether the windows of the workbook are protected.
Public propertyRangeSelectionMethod
Gets or sets the range selection method.
Public propertyReadOnlyRecommended
Gets or sets a value indicating whether the workbook is read only recommended.
Public propertyWorkbookView
Public propertyWorksheets
Gets the worksheets.
Top
See Also

Reference