Version

Search Results

Item Property (WorkbookColorPalette)

Gets or sets a color in the palette. Syntax Parameters index The index of the color to get or set in the palette. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than 0 or greater than 55. System.ArgumentException The value assigned is an empty color, a system color, or is not opa...

Reset Method (WorkbookColorPalette)

Resets the palette back to the default colors for Microsoft Excel. Syntax

WorkbookEncryptionMode Enumeration

Represents the various encryption modes that can be used to encrypt documents saved in the 2007 file formats and later. Syntax Members Member Description Agile Agile encryption used in Excel 2010 and later Standard Standard encryption used in Excel 2007 and later

WorkbookFormat Enumeration

Represents the various file formats in which a workbook can be saved. Syntax Members Member Description Excel2007 The Excel 2007 XML file format. Excel2007MacroEnabled The Excel 2007 Macro-Enabled XML file format. Excel2007MacroEnabledTemplate The Excel 2007 Macro-Enabled Template XML file format. Excel2007Templat...

WorkbookLoadOptions Class

Contains the options related to loading a workbook from a file or stream. Syntax

WorkbookLoadOptions Class Members

Public Constructors Public Properties

AutoResumeCalculations Property

Returns or sets a boolean indicating whether the Workbook will automatically call its ResumeCalculations methods before the Load method returns. Syntax Remarks When the Load method starts the SuspendCalculations is invoked so that no calculations occurs as the load is in progress. When the Load operation is comple...

Culture Property (WorkbookLoadOptions)

Returns or sets the value for the Workbook.Culture property. Syntax

IsDuplicateFormulaParsingOptimized Property

Returns or sets a boolean indicating whether duplicate formulas parsed during the load will be optimized for faster loading of the workbook. Syntax Remarks By default when an exact duplicate of a formula string is encountered during the load, the previously parsed formula will be cloned rather than reparsing the s...