Skip to main content
Row

IWorkbook Members

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

Properties

Name Description
ChartSheets Provides access to a collection of chart sheets contained in the workbook.
Clipboard Provides access to the object used for working with the system Clipboard. Inherited from ISpreadsheetComponent.
ColorPalette Returns a color palette for the spreadsheet document.
CreatesIntersectedBricks Inherited from IBasePrintable.
CurrentAuthor Gets the system username.
CustomFunctions Provides access to a collection of custom functions in a workbook.
CustomXmlParts Provides access to a workbook’s collection of custom XML parts.
DefinedNames Gets the collection of defined names whose scope is the current workbook.
DocumentProperties Provides access to the document properties associated with a workbook.
DocumentSettings Provides access to the settings that specify how the calculation is performed and what reference style is used.
ExternalWorkbooks Provides access to the collection of source workbooks used for creating external references in the current workbook.
FormulaEngine Provides access to a FormulaEngine object to parse or evaluate a formula.
Functions Provides access to the built-in functions in a workbook.
GlobalCustomFunctions Provides access to a collection of custom functions which are not limited in scope to the workbook in which the functions reside.
HasMacros Determines whether the workbook has VBA projects (macros).
History Provides access to the history of operations performed in a workbook.
IsDisposed Gets a value indicating whether a workbook has been disposed of.
IsProtected Gets whether the workbook is protected.
MailMergeDataMember Specifies the member of the mail merge data source.
MailMergeDataSource Specifies the data source for the mail merge.
MailMergeOptions Provides access to the mail merge options.
MailMergeParameters Provides access to a collection of parameters for queries used to obtain data in mail merge.
Model For internal use.
Modified Gets or sets whether the document content was modified since it was last saved. Inherited from ISpreadsheetComponent.
Options Provides access to various options which can be specified for the workbook. Inherited from ISpreadsheetComponent.
Path Gets the path to the spreadsheet file loaded as an external workbook. Inherited from ExternalWorkbook.
PivotCaches Provides access to the collection of all the PivotTable caches in the specified workbook.
Range Provides access to the cell range in the worbook.
RealTimeData Provides access to an object that is used to manually update real-time data and reconnect to data servers.
Sheets Provides access to a collection of all sheets contained in the workbook.
Styles Provides access to the collection of cell styles in the current workbook.
TableStyles Provides access to the collection of styles to format tables and pivot tables in the workbook.
Tag Gets or sets the data associated with an IWorkbook object.
Theme Returns the theme applied to the workbook.
Unit Gets or sets a unit of measure used in the workbook. Inherited from ISpreadsheetComponent.
Worksheets Returns the collection of worksheets in a workbook.

Methods

Name Description
AddService(Type, ServiceCreatorCallback, Boolean) Adds the specified service to the service container, and optionally promotes the service to parent service containers. Inherited from IServiceContainer.
AddService(Type, ServiceCreatorCallback) Adds the specified service to the service container. Inherited from IServiceContainer.
AddService(Type, Object, Boolean) Adds the specified service to the service container, and optionally promotes the service to any parent service containers. Inherited from IServiceContainer.
AddService(Type, Object) Adds the specified service to the service container. Inherited from IServiceContainer.
Calculate() Forces recalculation of the workbook.
Calculate(CellRange) Forces recalculation of the specified cell range in a worksheet.
Calculate(Worksheet) Forces recalculation of the specified worksheet in a workbook.
CalculateFull() Forces a full calculation of the data in a workbook.
CalculateFullRebuild() Forces a full calculation of cell formulas in a workbook.
CreateArea(String, BrickGraphics) When implemented by a class, creates report elements (bricks) for a specific area. Inherited from IBasePrintable.
CreateNewDocument() Creates and loads a new empty workbook. Inherited from ISpreadsheetComponent.
Dispose() Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. Inherited from IDisposable.
Evaluate(String, FormulaEvaluationContext) Evaluates the specified formula in a certain context.
Evaluate(String) Evaluates the specified formula.
ExportToHtml(Stream, CellRange) Exports the specified range to the specified stream in HTML format.
ExportToHtml(Stream, Worksheet) Exports the specified worksheet to the specified stream in HTML format.
ExportToHtml(Stream, HtmlDocumentExporterOptions) Exports the document’s data to the specified stream in HTML format using the specified options.
ExportToHtml(Stream, Int32) Exports the specified worksheet to the specified stream in HTML format.
ExportToHtml(String, CellRange) Exports the specified range to the specified file in HTML format.
ExportToHtml(String, Worksheet) Exports the specified worksheet to the specified file in HTML format.
ExportToHtml(String, HtmlDocumentExporterOptions) Exports the document’s data to the specified file in HTML format using the specified options.
ExportToHtml(String, Int32) Exports the specified worksheet to the specified file in HTML format.
ExportToPdf(Stream, PdfExportOptions) Exports the workbook to the specified stream in PDF format using the specified options.
ExportToPdf(Stream) Exports the workbook to the specified stream in PDF format.
ExportToPdf(String, PdfExportOptions) Exports the workbook to the specified file path in PDF format using the specified options.
ExportToPdf(String) Exports the workbook to the specified file path in PDF format.
Finalize(PrintingSystemBase, LinkBase) If implemented by a class, finalizes the printing of the report. Inherited from IBasePrintable.
GenerateMailMergeDocuments() Performs the mail merge and returns the collection of resulting workbooks.
GetService(Type) Gets the service object of the specified type. Inherited from IServiceProvider.
Initialize(PrintingSystemBase, LinkBase) When implemented by a class, initializes a control for report creation. Inherited from IBasePrintable.
LoadDocument(Byte[], DocumentFormat) Loads a document from a byte array. Inherited from ISpreadsheetComponent.
LoadDocument(Byte[]) Loads the document from a Byte[] array. Inherited from ISpreadsheetComponent.
LoadDocument(Stream, DocumentFormat) Loads a document from a stream, specifying the document format. Inherited from ISpreadsheetComponent.
LoadDocument(Stream) Loads the document from a stream. Inherited from ISpreadsheetComponent.
LoadDocument(String, DocumentFormat) Loads a document from a file, specifying the document format. Inherited from ISpreadsheetComponent.
LoadDocument(String) Loads a document from a file. Inherited from ISpreadsheetComponent.
Protect(String, Boolean, Boolean) Protects the structure and windows of a workbook.
RemoveService(Type, Boolean) Removes the specified service type from the service container, and optionally promotes the service to parent service containers. Inherited from IServiceContainer.
RemoveService(Type) Removes the specified service type from the service container. Inherited from IServiceContainer.
SaveDocument(DocumentFormat, EncryptionSettings) Saves a document to an array of bytes in the specified format with the specified encryption settings. Inherited from ISpreadsheetComponent.
SaveDocument(DocumentFormat) Saves a document to an array of bytes in the specified format. Inherited from ISpreadsheetComponent.
SaveDocument(Stream, DocumentFormat, EncryptionSettings) Saves the document to a stream, specifying the document format anf encryption options. Inherited from ISpreadsheetComponent.
SaveDocument(Stream, DocumentFormat) Saves the document to a stream, specifying the document format. Inherited from ISpreadsheetComponent.
SaveDocument(String, DocumentFormat, EncryptionSettings) Saves the document to a file, specifying the document format and encryption options. Inherited from ISpreadsheetComponent.
SaveDocument(String, DocumentFormat) Saves the document to a file, specifying the document format. Inherited from ISpreadsheetComponent.
SaveDocument(String, EncryptionSettings) Saves the document to the specified file with the specified encryption options. The file format is identified by the file extension. Inherited from ISpreadsheetComponent.
SaveDocument(String) Saves the document to the specified file. The file format is identified by the file extension. Inherited from ISpreadsheetComponent.
Search(String, SearchOptions) Performs a search in the current document using specified options.
Search(String) Performs a search in the current document using the default parameters.
Unprotect(String) Removes protection from a workbook.

Events

Name Description
ActiveSheetChanged Occurs after an active worksheet in a workbook has been changed. Inherited from ISpreadsheetComponent.
ActiveSheetChanging Occurs when an active worksheet in a workbook is about to be changed. Inherited from ISpreadsheetComponent.
BeforeEncodingDetection Occurs before detecting the encoding of the loaded CSV or TXT data. Inherited from ISpreadsheetComponent.
BeforeExport Occurs before the document is saved (exported to a certain format). Inherited from ISpreadsheetComponent.
BeforeImport Occurs before a document is loaded (imported from an external source). Inherited from ISpreadsheetComponent.
BeforePrintSheet Occurs before printing a workbook. Inherited from ISpreadsheetComponent.
ClipboardDataObtained Occurs after data on the Clipboard is obtained and recognized, but before data is actually pasted. Inherited from ISpreadsheetComponent.
ClipboardDataPasted Occurs after data has been pasted from the Clipboard onto a worksheet. Inherited from ISpreadsheetComponent.
ClipboardDataPasting Occurs before data is pasted from the Clipboard. Inherited from ISpreadsheetComponent.
ColumnsInserted Occurs after new columns have been added to a worksheet. Inherited from ISpreadsheetComponent.
ColumnsInserting Occurs when new columns are about to be inserted into a worksheet. Inherited from ISpreadsheetComponent.
ColumnsRemoved Occurs after columns have been deleted from a worksheet. Inherited from ISpreadsheetComponent.
ColumnsRemoving Occurs when columns are about to be deleted from a worksheet. Inherited from ISpreadsheetComponent.
ColumnWidthChanged Occurs after the column width was changed. Inherited from ISpreadsheetComponent.
CommentInserted Occurs when a comment is inserted. Inherited from ISpreadsheetComponent.
CommentInserting Occurs before inserting a comment. Inherited from ISpreadsheetComponent.
CommentRemoved Occurs when a comment is deleted. Inherited from ISpreadsheetComponent.
CommentRemoving Occurs before deleting a comment. Inherited from ISpreadsheetComponent.
CopiedRangePasted Occurs after the range content has been pasted into target cells. Inherited from ISpreadsheetComponent.
CopiedRangePasting Occurs before the range content is pasted into target cells. Inherited from ISpreadsheetComponent.
CustomAssemblyLoading Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge and allows you to cancel loading. Inherited from ISpreadsheetComponent.
DefinedNameConflictResolving Occurs when a formula or sheet being moved or copied contains the defined name, which already exists on the destination worksheet or workbook. Inherited from ISpreadsheetComponent.
DocumentClosing Occurs when a document that has not yet been saved is about to be closed. Inherited from ISpreadsheetComponent.
DocumentLoaded Occurs after a document is loaded. Inherited from ISpreadsheetComponent.
DocumentSaved Occurs after a document has been saved. Inherited from ISpreadsheetComponent.
EmptyDocumentCreated Occurs when a new document is created. Inherited from ISpreadsheetComponent.
EncryptedFileIntegrityCheckFailed Raises when the encrypted file did not pass the data integrity verification. Inherited from ISpreadsheetComponent.
EncryptedFilePasswordCheckFailed Occurs when the encryption password is empty or invalid. Inherited from ISpreadsheetComponent.
EncryptedFilePasswordRequest Raises when the WorkbookImportOptions.Password property is not set or contains a wrong password. Inherited from ISpreadsheetComponent.
InitializeDocument Occurs before a document is loaded. Handle this event to set initial document settings. Inherited from ISpreadsheetComponent.
InvalidFormatException Fires when the supplied data could not be recognized as data in the assumed format for import. Inherited from ISpreadsheetComponent.
ModifiedChanged Occurs when the value of the ISpreadsheetComponent.Modified property is changed. Inherited from ISpreadsheetComponent.
PanesFrozen Occurs after a worksheet area has been frozen. Inherited from ISpreadsheetComponent.
PanesUnfrozen Occurs after a frozen worksheet area has been unlocked. Inherited from ISpreadsheetComponent.
RangeCopied Occurs after the range content has been copied. Inherited from ISpreadsheetComponent.
RangeCopying Occurs before a cell range is copied in a worksheet. Inherited from ISpreadsheetComponent.
RowHeightChanged Occurs after the row height was changed. Inherited from ISpreadsheetComponent.
RowsInserted Occurs after new rows have been added to a worksheet. Inherited from ISpreadsheetComponent.
RowsInserting Occurs when new rows are about to be inserted into a worksheet. Inherited from ISpreadsheetComponent.
RowsRemoved Occurs after rows have been deleted from a worksheet. Inherited from ISpreadsheetComponent.
RowsRemoving Occurs when rows are about to be deleted from a worksheet. Inherited from ISpreadsheetComponent.
SchemaChanged Occurs when the schema of an external workbook is changed (a new worksheet is added, a new defined name appears etc.). Inherited from ExternalWorkbook.
ScrollPositionChanged Occurs when the scroll position changes in a worksheet. Inherited from ISpreadsheetComponent.
SelectionChanged Fires in response to changing cell selection in a worksheet. Inherited from ISpreadsheetComponent.
ShapeInserted Occurs after a drawing object has been inserted into a worksheet. Inherited from ISpreadsheetComponent.
ShapeRemoved Occurs after a drawing object has been removed from a worksheet. Inherited from ISpreadsheetComponent.
ShapeRemoving Occurs before a drawing object is removed from a worksheet. Inherited from ISpreadsheetComponent.
ShapesCopying Occurs before a drawing object is copied in a worksheet. Inherited from ISpreadsheetComponent.
SheetInserted Occurs after a new worksheet has been added to a workbook. Inherited from ISpreadsheetComponent.
SheetRemoved Occurs after a worksheet has been removed from a workbook. Inherited from ISpreadsheetComponent.
SheetRemoving Occurs when a worksheet is about to be removed from a workbook. Inherited from ISpreadsheetComponent.
SheetRenamed Occurs after a worksheet has been renamed. Inherited from ISpreadsheetComponent.
SheetRenaming Occurs when a worksheet is about to be renamed. Inherited from ISpreadsheetComponent.
UnitChanged Fires after a unit of measurement used in the workbook is changed. Inherited from ISpreadsheetComponent.
UnitChanging Fires before a unit of measurement used within the workbook is changed. Inherited from ISpreadsheetComponent.
See Also