Back to Devexpress

IWorkbook Properties

officefileapi-devexpress-dot-spreadsheet-dot-iworkbook-dot-underscore-properties.md

latest7.0 KB
Original Source

IWorkbook Properties

A workbook loaded into the Spreadsheet control (for WinForms, WPF, and ASP.NET).

NameDescription
ChartSheetsProvides access to a collection of chart sheets contained in the workbook.
ClipboardProvides access to the object used for working with the system Clipboard. Inherited from ISpreadsheetComponent.
ColorPaletteReturns a color palette for the spreadsheet document.
CreatesIntersectedBricksInherited from IBasePrintable.
CurrentAuthorGets the system username.
CustomFunctionsProvides access to a collection of custom functions in a workbook.
CustomXmlPartsProvides access to a workbook’s collection of custom XML parts.
DefinedNamesGets the collection of defined names whose scope is the current workbook.
DocumentPropertiesProvides access to the document properties associated with a workbook.
DocumentSettingsProvides access to the settings that specify how the calculation is performed and what reference style is used.
ExternalWorkbooksProvides access to the collection of source workbooks used for creating external references in the current workbook.
FormulaEngineProvides access to a FormulaEngine object to parse or evaluate a formula.
FunctionsProvides access to the built-in functions in a workbook.
GlobalCustomFunctionsProvides access to a collection of custom functions which are not limited in scope to the workbook in which the functions reside.
HasMacrosDetermines whether the workbook has VBA projects (macros).
HistoryProvides access to the history of operations performed in a workbook.
IsDisposedGets a value indicating whether a workbook has been disposed of.
IsProtectedGets whether the workbook is protected.
MailMergeDataMemberSpecifies the member of the mail merge data source.
MailMergeDataSourceSpecifies the data source for the mail merge.
MailMergeOptionsProvides access to the mail merge options.
MailMergeParametersProvides access to a collection of parameters for queries used to obtain data in mail merge.
ModelFor internal use.
ModifiedGets or sets whether the document content was modified since it was last saved. Inherited from ISpreadsheetComponent.
OptionsProvides access to various options which can be specified for the workbook. Inherited from ISpreadsheetComponent.
PathGets the path to the spreadsheet file loaded as an external workbook. Inherited from ExternalWorkbook.
PivotCachesProvides access to the collection of all the PivotTable caches in the specified workbook.
RangeProvides access to the cell range in the worbook.
RealTimeDataProvides access to an object that is used to manually update real-time data and reconnect to data servers.
SheetsProvides access to a collection of all sheets contained in the workbook.
StylesProvides access to the collection of cell styles in the current workbook.
TableStylesProvides access to the collection of styles to format tables and pivot tables in the workbook.
TagGets or sets the data associated with an IWorkbook object.
ThemeReturns the theme applied to the workbook.
UnitGets or sets a unit of measure used in the workbook. Inherited from ISpreadsheetComponent.
WorksheetsReturns the collection of worksheets in a workbook.

See Also

IWorkbook Interface

IWorkbook Members

DevExpress.Spreadsheet Namespace