Version 21.2

Workbook Class Properties

For a list of all members of this type, see Workbook members.

Public Properties
 NameDescription
Public PropertyCalculationModeGets or sets the value which indicates how a formula will be recalculated when a referenced value changes.  
Public PropertyCellReferenceModeGets or sets the value which indicates the way cells in the workbook are referenced.  
Public PropertyCultureGets or sets the culture to use as the current culture for the workbook when doing any culture-aware conversions or comparisons.  
Public PropertyCurrentFormatGets the current format of the workbook. This is the format which will be used when saving and imposing format restrictions.  
Public PropertyCustomTableStylesGets the collection of custom table styles in the workbook.  
Public PropertyCustomViewsGets the collection of custom views for the workbook.  
Public PropertyDateSystemGets or sets the date system used internally by Microsoft Excel.  
Public PropertyDefaultTableStyleGets or sets the default style for tables in the workbook.  
Public PropertyDocumentPropertiesGets the properties associated with the workbook document.  
Public PropertyEditingCultureThe editing culture affects certain language specific features such as formatting of dates. or comparisons.  
Public PropertyFileWriteProtectedByGets the name of the user who initially added file write protection to the document.  
Public PropertyHasFileWriteProtectionPasswordGets the value indicating whether the Workbook has a file write protection password that will be used to protect saved files or streams.  
Public PropertyHasOpenPasswordGets the value indicating whether the Workbook has an open password and will therefore be encrypted on subsequent saves.  
Public PropertyHasProtectionPasswordReturns a boolean indicating if the Workbook has been protected with a password.  
Public PropertyIsFileWriteProtectedGets the value indicating whether the Workbook was loaded with file write protection and the correct password has not yet been provided to ValidateFileWriteProtectionPassword.  
Public PropertyIsProtectedReturns a boolean indicating if the Workbook has been protected.  
Public PropertyIterativeCalculationsEnabledGets or sets the value which indicates whether iterations are allowed while calculating formulas containing circular references.  
Public PropertyMaxChangeInIterationGets or sets the maximum change of the values in a formula between iterations which will exit from iteration.  
Public PropertyMaxColumnCountGets the maximum number of columns allowed in each worksheet based on the CurrentFormat.  
Public PropertyMaxRecursionIterationsGets or sets the maximum number of times formulas should be iteratively calculated.  
Public PropertyMaxRowCountGets the maximum number of rows allowed in each worksheet based on the CurrentFormat.  
Public PropertyNamedReferencesGets the collection of named references in the workbook.  
Public PropertyPaletteGets the color palette used when the saved file is opened in Microsoft Excel 2003 and earlier versions.  
Public PropertyPrecisionGets or sets the precision to use when obtaining a cell's value.  
Public PropertyProtectedGets or sets the value which indicates whether the workbook is protected.  
Public PropertyProtectionReturns an object that provides information used when the Workbook has been protected.  
Public PropertyRecalculateBeforeSaveGets or sets the value which indicates whether the workbook should recalculate all formulas before saving.  
Public PropertySaveExternalLinkedValuesGets or sets the value which indicates whether to save values linked from external workbooks.  
Public PropertyScreenDpiGets or sets the Dpi to use when calculating row and column sizes for the workbook. If empty, the system Dpi will be used.  
Public PropertySheetsGets the collection of sheets in the workbook.  
Public PropertyShouldRemoveCarriageReturnsOnSaveGets or sets the value which indicates whether carriage return characters should be removed from string values in cells when the workbook is saved to an Excel file.  
Public PropertyStandardTableStylesGets the read-only collection of preset table styles in the workbook.  
Public PropertyStylesGets the collection of custom styles in the workbook.  
Public Propertystatic (Shared in Visual Basic)SystemDpiGets or sets the default Dpi to use when calculating row and column sizes for the workbook. If empty, the resolved system Dpi will be used.  
Public PropertyValidateFormatStringsGets or sets the value indicating whether the format strings should be validated when they are set.  
Public PropertyWindowOptionsGets the options which control various workbook level display properties.  
Public PropertyWorksheetsGets the collection of worksheets in the workbook.  
See Also

View on GitHub