Skip to main content
Row

Workbook Members

A non-visual component that allows you to generate and modify spreadsheet documents.

Constructors

Name Description
Workbook() Initializes a new instance of the Workbook class with the default settings.

Properties

Name Description
ChartSheets

Provides access to a collection of chart sheets contained in the workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Clipboard

Provides access to the object used for working with the system clipboard.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

ColorPalette

Returns a color palette for the workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

CurrentAuthor

Gets the system username.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

CustomFunctions

Provides access to a collection of custom functions in a workbook

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

CustomXmlParts

Provides access to a workbook’s collection of custom XML parts.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

DefinedNames

Gets the collection of defined names whose scope is the current workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

DocumentProperties

Provides access to the document properties associated with a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

DocumentSettings

Provides access to the settings that specify how the calculation is performed and what reference style is used.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

ExternalWorkbooks

Provides access to the collection of source workbooks used for creating external references in the current workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

FormulaEngine

Provides access to an object used to parse and evaluate formulas.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Functions

Provides access to the built-in functions in a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

GlobalCustomFunctions

Provides access to a collection of custom functions which are not limited in scope to the workbook in which the functions reside.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

HasMacros

Determines whether the workbook has VBA projects (macros).

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

History

Provides access to the history of operations performed in a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

IsDisposed

Indicates whether a workbook has been disposed of.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

IsProtected

Indicates whether a workbook is protected.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

IsUpdateLocked

Returns a value indicating whether the Workbook object is locked for update.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

MailMergeDataMember

Gets or sets a specific data member in a data source that contains several tables or members.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

MailMergeDataSource

Gets or sets the data source for the mail merge.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

MailMergeOptions

Provides access to mail merge options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

MailMergeParameters

Provides access to a collection of query parameters used to obtain data in mail merge.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Model For internal use.
Modified

Gets or sets whether the workbook content was modified since it was last saved.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Options

Returns an object that contains document options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Path

Gets the file name into which the workbook is saved or from which it is loaded.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

PivotCaches

Returns the collection of all PivotTable caches in a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Range

Provides access to the cell range in the workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

RealTimeData

Returns an object used to manually update real-time data and reconnect to data servers.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Sheets

Provides access to a collection of all sheets contained in the workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Styles

Provides access to the workbook’s collection of cell styles.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

TableStyles

Provides access to the collection of styles to format tables in the workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Tag

Gets or sets data associated with a Workbook object.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Theme

Returns the theme applied to the workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Unit

Gets or sets a unit of measure used in the workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Worksheets

Returns the collection of worksheets in a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Methods

Name Description
AddService(Type, ServiceCreatorCallback, Boolean)

Adds the specified service to the service container.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

AddService(Type, ServiceCreatorCallback)

Adds the specified service to the service container.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

AddService(Type, Object, Boolean)

Adds the specified service to the service container.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

AddService(Type, Object)

Adds the specified service to the service container.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

BeginUpdate()

Locks the Workbook object until the Workbook.EndUpdate method is called.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Calculate()

Forces recalculation of the workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Calculate(CellRange)

Forces recalculation of the specified cell range in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Calculate(Worksheet)

Forces recalculation of the specified worksheet in a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

CalculateFull()

Forces a full calculation of a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

CalculateFullRebuild()

Forces a full calculation of a workbook and rebuilds the dependencies.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

CancelUpdate() For internal use. Use the Workbook.EndUpdate method instead.
CreateNewDocument()

Creates and loads a new empty workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

Dispose()

Releases resources associated with a Workbook instance.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

EndUpdate()

Unlocks the Workbook object.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
Evaluate(String, FormulaEvaluationContext)

Evaluates the specified formula in a certain context.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Evaluate(String)

Evaluates the specified formula.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtml(Stream, CellRange)

Exports the specified range to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtml(Stream, Worksheet)

Exports the specified worksheet to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtml(Stream, HtmlDocumentExporterOptions)

Exports the document’s data to the specified stream in HTML format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtml(Stream, Int32)

Exports the specified worksheet to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtml(String, CellRange)

Exports the specified range to the specified file in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtml(String, Worksheet)

Exports the specified worksheet to the specified file in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtml(String, HtmlDocumentExporterOptions)

Exports the document’s data to the specified file in HTML format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtml(String, Int32)

Exports the specified worksheet to the specified file in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, CellRange, IProgress<Int32>)

Asynchronously exports the specified cell range to a stream in HTML format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, CellRange, CancellationToken, IProgress<Int32>)

Asynchronously exports the specified cell range to a stream in HTML format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, CellRange, CancellationToken)

Asynchronously exports the specified range to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, CellRange)

Asynchronously exports the specified range to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, Worksheet, IProgress<Int32>)

Asynchronously exports the specified worksheet to a stream in HTML format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, Worksheet, CancellationToken, IProgress<Int32>)

Asynchronously exports the specified worksheet to a stream in HTML format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, Worksheet, CancellationToken)

Asynchronously exports the specified range to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, Worksheet)

Asynchronously exports the specified worksheet to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, HtmlDocumentExporterOptions, IProgress<Int32>)

Asynchronously exports document data to a stream in HTML format. Allows you to specify export options and implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, HtmlDocumentExporterOptions, CancellationToken, IProgress<Int32>)

Asynchronously exports document data to a stream in HTML format. Allows you to specify export options, implement progress notifications, and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, HtmlDocumentExporterOptions, CancellationToken)

Asynchronously exports the document’s data to the specified stream in HTML format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, HtmlDocumentExporterOptions)

Asynchronously exports the document’s data to the specified stream in HTML format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, Int32, IProgress<Int32>)

Asynchronously exports the specified worksheet to a stream in HTML format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, Int32, CancellationToken, IProgress<Int32>)

Asynchronously exports the specified worksheet to a stream in HTML format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, Int32, CancellationToken)

Asynchronously exports the specified worksheet to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(Stream, Int32)

Asynchronously exports the specified range to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, CellRange, IProgress<Int32>)

Asynchronously exports the specified cell range to a file in HTML format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, CellRange, CancellationToken, IProgress<Int32>)

Asynchronously exports the specified cell range to a file in HTML format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, CellRange, CancellationToken)

Asynchronously exports the specified range to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, CellRange)

Asynchronously exports the specified worksheet to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, Worksheet, IProgress<Int32>)

Asynchronously exports the specified worksheet to a file in HTML format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, Worksheet, CancellationToken, IProgress<Int32>)

Asynchronously exports the specified worksheet to a file in HTML format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, Worksheet, CancellationToken)

Asynchronously exports the specified worksheet to the specified file in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, Worksheet)

Asynchronously exports the specified worksheet to the specified file in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, HtmlDocumentExporterOptions, IProgress<Int32>)

Asynchronously exports document data to a file in HTML format. Allows you to specify export options and implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, HtmlDocumentExporterOptions, CancellationToken, IProgress<Int32>)

Asynchronously exports document data to a file in HTML format. Allows you to specify export options, implement progress notifications, and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, HtmlDocumentExporterOptions, CancellationToken)

Asynchronously exports the document’s data to the specified file in HTML format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, HtmlDocumentExporterOptions)

Asynchronously exports the document’s data to the specified file in HTML format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, Int32, IProgress<Int32>)

Asynchronously exports the specified worksheet to a file in HTML format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, Int32, CancellationToken, IProgress<Int32>)

Asynchronously exports the specified worksheet to a file in HTML format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, Int32, CancellationToken)

Asynchronously exports the specified worksheet to the specified stream in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToHtmlAsync(String, Int32)

Asynchronously exports the specified worksheet to the specified file in HTML format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdf(Stream, PdfExportOptions, IEnumerable<String>)

Defines export options and exports the specified sheets to the stream in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdf(Stream, PdfExportOptions, String[])

Defines export options and exports the specified sheets to the stream in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdf(Stream, PdfExportOptions)

Exports the workbook to the specified stream in PDF format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdf(Stream)

Exports the workbook to the specified stream in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdf(String, PdfExportOptions, IEnumerable<String>)

Defines export options and exports the specified sheets to the file in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdf(String, PdfExportOptions, String[])

Defines export options and exports the specified sheets to the file in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdf(String, PdfExportOptions)

Exports the workbook to the specified file path in PDF format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdf(String)

Exports the workbook to the specified file path in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, PdfExportOptions, IEnumerable<String>, IProgress<Int32>)

Asynchronously exports the specified sheets to a stream in PDF format. Allows you to specify export options and implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, PdfExportOptions, IEnumerable<String>, CancellationToken, IProgress<Int32>)

Asynchronously exports the specified sheets to a stream in PDF format. Allows you to specify export options, implement progress notifications, and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, PdfExportOptions, IEnumerable<String>, CancellationToken)

Defines export options and asynchronously exports the specified sheets to the stream in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, PdfExportOptions, IEnumerable<String>)

Asynchronously exports the workbook to the specified file path in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, PdfExportOptions, IProgress<Int32>)

Asynchronously exports the workbook to a stream in PDF format. Allows you to specify export options and implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, PdfExportOptions, String[])

Asynchronously exports specific worksheets to the specified file path in PDF format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, PdfExportOptions, CancellationToken, IProgress<Int32>)

Asynchronously exports the workbook to a stream in PDF format. Allows you to specify export options, implement progress notifications, and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, PdfExportOptions, CancellationToken)

Asynchronously exports the workbook to the specified stream in PDF format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, PdfExportOptions)

Asynchronously exports the workbook to the specified stream in PDF format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, IProgress<Int32>)

Asynchronously exports the workbook to a stream in PDF format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, CancellationToken, IProgress<Int32>)

Asynchronously exports the workbook to a stream in PDF format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream, CancellationToken)

Asynchronously exports the workbook to the specified stream in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(Stream)

Asynchronously exports the workbook to the specified stream in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, PdfExportOptions, IEnumerable<String>, IProgress<Int32>)

Asynchronously exports the specified sheets to a file in PDF format. Allows you to specify export options and implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, PdfExportOptions, IEnumerable<String>, CancellationToken, IProgress<Int32>)

Asynchronously exports the specified sheets to a file in PDF format. Allows you to specify export options, implement progress notifications, and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, PdfExportOptions, IEnumerable<String>, CancellationToken)

Defines export options and asynchronously exports the specified sheets to the file in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, PdfExportOptions, IEnumerable<String>)

Defines export options and asynchronously exports the specified sheets to the file in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, PdfExportOptions, IProgress<Int32>)

Asynchronously exports the workbook to a file in PDF format. Allows you to specify export options and implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, PdfExportOptions, String[])

Defines export options and asynchronously exports the specified sheets to the file in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, PdfExportOptions, CancellationToken, IProgress<Int32>)

Asynchronously exports the workbook to a file in PDF format. Allows you to specify export options, implement progress notifications, and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, PdfExportOptions, CancellationToken)

Asynchronously exports the workbook to the specified file path in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, PdfExportOptions)

Asynchronously exports the workbook to the specified stream in PDF format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, IProgress<Int32>)

Asynchronously exports the workbook to a file in PDF format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, CancellationToken, IProgress<Int32>)

Asynchronously exports the workbook to a file in PDF format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String, CancellationToken)

Asynchronously exports the workbook to the specified file path in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ExportToPdfAsync(String)

Asynchronously exports the workbook to the specified file path in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

GenerateMailMergeDocuments()

Performs a mail merge and returns the collection of resulting workbooks.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

GetHashCode() Serves as the default hash function. Inherited from Object.
GetService(Type)

Gets the service object of the specified type.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

GetService<T>()

Gets the specified service.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

GetType() Gets the Type of the current instance. Inherited from Object.
LoadDocument(Byte[], DocumentFormat)

Loads a document in the specified format from a byte array.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocument(Byte[])

Loads a document from a byte array.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocument(Stream, DocumentFormat)

Loads a document in the specified format from a stream.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocument(Stream)

Loads a document from a stream.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocument(String, DocumentFormat)

Loads a document in the specified format from a file.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocument(String)

Loads a document from a file.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Byte[], DocumentFormat, IProgress<Int32>)

Asynchronously loads a document in the specified format from a byte array and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Byte[], DocumentFormat, CancellationToken, IProgress<Int32>)

Asynchronously loads a document in the specified format from a byte array. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Byte[], DocumentFormat, CancellationToken)

Loads a document asynchronously in the specified format from a byte array.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Byte[], DocumentFormat)

Loads a document asynchronously in the specified format from a byte array.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Byte[], IProgress<Int32>)

Asynchronously loads a document from a byte array and allows you to implement progress notifications. The file format is determined based on document content

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Byte[], CancellationToken, IProgress<Int32>)

Asynchronously loads a document from a byte array (the file format is determined based on document content). Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Byte[], CancellationToken)

Loads a document asynchronously from a byte array.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Byte[])

Loads a document asynchronously from a byte array.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Stream, DocumentFormat, IProgress<Int32>)

Asynchronously loads a document in the specified format from a stream and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Stream, DocumentFormat, CancellationToken, IProgress<Int32>)

Asynchronously loads a document in the specified format from a stream. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Stream, DocumentFormat, CancellationToken)

Loads a document asynchronously in the specified format from a stream.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Stream, DocumentFormat)

Loads a document asynchronously in the specified format from a stream.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Stream, IProgress<Int32>)

Asynchronously loads a document from a stream and allows you to implement progress notifications. The file format is determined based on document content.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Stream, CancellationToken, IProgress<Int32>)

Asynchronously loads a document from a stream (the file format is determined based on document content). Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Stream, CancellationToken)

Loads a document asynchronously from a stream.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(Stream)

Loads a document asynchronously from a stream.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(String, DocumentFormat, IProgress<Int32>)

Asynchronously loads a document in the specified format from a file and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(String, DocumentFormat, CancellationToken, IProgress<Int32>)

Asynchronously loads a document in the specified format from a file. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(String, DocumentFormat, CancellationToken)

Loads a document asynchronously in the specified format from a file.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(String, DocumentFormat)

Loads a document asynchronously in the specified format from a file.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(String, IProgress<Int32>)

Asynchronously loads a document from a file and allows you to implement progress notifications. The file format is determined based on document content.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(String, CancellationToken, IProgress<Int32>)

Asynchronously loads a document from a file (the file format is determined based on document content). Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(String, CancellationToken)

Loads a document asynchronously from a file.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentAsync(String)

Loads a document asynchronously from a file.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentProperties(Byte[], DocumentFormat)

Loads document properties for a workbook from the specified byte array.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentProperties(Byte[])

Loads document properties for a workbook from the specified byte array. The document format is determined automatically.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentProperties(Stream, DocumentFormat)

Loads document properties for a workbook from the specified stream.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentProperties(Stream)

Loads document properties for a workbook from the specified stream. The document format is determined automatically.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentProperties(String, DocumentFormat)

Loads document properties from the specified workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

LoadDocumentProperties(String)

Loads document properties from the specified workbook. The document format is determined automatically.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
Merge(IWorkbook[]) static

Combines the specified workbooks into a new document.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Print()

Prints the document to the default printer.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Print(DXPrinterSettings, IEnumerable<String>) Defines cross-platform printer settings and prints the specified sheets.
Print(DXPrinterSettings, String[]) Defines cross-platform printer settings and prints the specified sheets.
Print(DXPrinterSettings) Defines printer settings and prints the workbook.
Print(PrinterSettings, IEnumerable<String>)

Defines printer settings and prints the specified sheets.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Print(PrinterSettings, String[])

Defines printer settings and prints the specified sheets.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Print(PrinterSettings)

Prints the document using the specified printer settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Protect(String, Boolean, Boolean)

Protects the structure and windows of a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
RemoveService(Type, Boolean)

Removes the service of the specified type from the service container.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

RemoveService(Type)

Removes the service of the specified type from the service container.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ReplaceService<T>(T)

Performs a service substitution.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocument(DocumentFormat, EncryptionSettings)

Saves the document to an array of bytes in the specified format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocument(DocumentFormat)

Saves a document to a byte array in the specified format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocument(Stream, DocumentFormat, EncryptionSettings)

Saves the document to a stream in the specified format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocument(Stream, DocumentFormat)

Saves the document to a stream in the specified format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocument(String, DocumentFormat, EncryptionSettings)

Saves the document to a file in the specified format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocument(String, DocumentFormat)

Saves the document to a file in the specified document format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocument(String, EncryptionSettings)

Saves the document to a file in the Excel or text format with the specified encryption settings. The file format is identified by the file extension.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocument(String)

Saves the document to a file in the Excel or text format. The file format is identified by the file extension.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(DocumentFormat, EncryptionSettings, IProgress<Int32>)

Asynchronously saves the document to a byte array in the specified file format, encrypts the output with a password, and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(DocumentFormat, EncryptionSettings, CancellationToken, IProgress<Int32>)

Asynchronously saves the document to a byte array in the specified format and encrypts the file with a password. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(DocumentFormat, EncryptionSettings, CancellationToken)

Asynchronously saves the document to an array of bytes in the specified format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(DocumentFormat, EncryptionSettings)

Asynchronously saves the document to an array of bytes in the specified format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(DocumentFormat, IProgress<Int32>)

Asynchronously saves the document to a byte array in the specified format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(DocumentFormat, CancellationToken, IProgress<Int32>)

Asynchronously saves the document to a byte array in the specified format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(DocumentFormat, CancellationToken)

Asynchronously saves the document to an array of bytes in the specified document format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(DocumentFormat)

Asynchronously saves the document to a byte array in the specified document format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(Stream, DocumentFormat, EncryptionSettings, IProgress<Int32>)

Asynchronously saves the document to a stream in the specified format, encrypts the file with a password, and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(Stream, DocumentFormat, EncryptionSettings, CancellationToken, IProgress<Int32>)

Asynchronously saves the document to a stream in the specified format and encrypts the file with a password. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(Stream, DocumentFormat, EncryptionSettings, CancellationToken)

Asynchronously saves the document to a stream in the specified document format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(Stream, DocumentFormat, EncryptionSettings)

Asynchronously saves the document to a stream in the specified document format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(Stream, DocumentFormat, IProgress<Int32>)

Asynchronously saves the document to a stream in the specified format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(Stream, DocumentFormat, CancellationToken, IProgress<Int32>)

Asynchronously saves the document to a stream in the specified format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(Stream, DocumentFormat, CancellationToken)

Asynchronously saves the document to a stream in the specified document format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(Stream, DocumentFormat)

Asynchronously saves the document to a stream in the specified document format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, DocumentFormat, EncryptionSettings, IProgress<Int32>)

Asynchronously saves the document to a file in the specified format, encrypts the file with a password, and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, DocumentFormat, EncryptionSettings, CancellationToken, IProgress<Int32>)

Asynchronously saves the document to a file in the specified format and encrypts the file with a password. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, DocumentFormat, EncryptionSettings, CancellationToken)

Asynchronously saves the document to a file in the specified format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, DocumentFormat, EncryptionSettings)

Asynchronously saves the document to a file in the specified document format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, DocumentFormat, IProgress<Int32>)

Asynchronously saves the document to a file in the specified format and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, DocumentFormat, CancellationToken, IProgress<Int32>)

Asynchronously saves the document to a file in the specified format. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, DocumentFormat, CancellationToken)

Asynchronously saves the document to a file in the specified document format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, DocumentFormat)

Asynchronously saves the document to a file in the specified document format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, EncryptionSettings, IProgress<Int32>)

Asynchronously saves the document to a file (the file format is defined by the file extension), encrypts the file with a password, and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, EncryptionSettings, CancellationToken, IProgress<Int32>)

Asynchronously saves the document to a file (the file format is defined by the file extension) and encrypts the file with a password. Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, EncryptionSettings, CancellationToken)

Asynchronously saves the document to a file in the specified format and with the specified encryption settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, EncryptionSettings)

Asynchronously saves the document to a file with the specified encryption settings. The file format is identified by the file extension.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, IProgress<Int32>)

Asynchronously saves the document to a file (the file format is defined by the file extension) and allows you to implement progress notifications.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, CancellationToken, IProgress<Int32>)

Asynchronously saves the document to a file (the file format is defined by the file extension). Allows you to implement progress notifications and cancel the operation.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String, CancellationToken)

Asynchronously saves the document to a file.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

SaveDocumentAsync(String)

Asynchronously saves the document to a file in the Excel or text format. The file format is identified by the file extension.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Search(String, SearchOptions)

Performs a search in the current document by using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Search(String)

Performs a search in the current document by using the default parameters.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

ToString() Returns a string that represents the current object. Inherited from Object.
Unprotect(String)

Removes protection from a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Events

Name Description
ActiveSheetChanged

Occurs after an active worksheet in a workbook has been changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ActiveSheetChanging

Occurs when an active worksheet in a workbook is about to be changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

BeforeEncodingDetection Occurs before detecting the encoding of the loaded CSV or TXT data.
BeforeExport

Occurs before the document is saved (exported to a certain format).

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

BeforeImport

Occurs before a document is loaded (imported from an external source).

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

BeforePrintSheet

Occurs before printing a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ClipboardDataObtained

Occurs after data on the clipboard is obtained and recognized, but before data is actually pasted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ClipboardDataPasted

Occurs after data has been pasted from the clipboard onto a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ClipboardDataPasting

Occurs before data is pasted into destination cells.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ColumnsInserted

Occurs after new columns have been added to a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ColumnsInserting

Occurs before new columns are added to a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ColumnsRemoved

Occurs after columns have been deleted from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ColumnsRemoving

Occurs before columns are removed from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ColumnWidthChanged

Occurs after the column width was changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

CommentInserted

Occurs after a comment was inserted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

CommentInserting

Occurs before a comment is inserted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

CommentRemoved

Occurs after a comment was deleted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

CommentRemoving

Occurs before a comment is deleted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ContentChanged

Occurs when a workbook’s undo history changes. The Undo history is not logged for a Workbook instance by default, so the event is not raised.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

CopiedRangePasted

Occurs after the range content has been pasted into target cells.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

CopiedRangePasting

Occurs before the range content is pasted into target cells.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

CustomAssemblyLoading

Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge. Allows you to cancel loading.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

DefinedNameConflictResolving

Occurs when the formula or sheet being moved or copied contains a defined name which already exists on the destination worksheet or workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

DocumentClosing

Occurs when a document that has not yet been saved is about to be closed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

DocumentLoaded

Occurs after a document is loaded.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

DocumentSaved

Occurs after a document has been saved.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

EmptyDocumentCreated

Occurs when a new document is created.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

EncryptedFileIntegrityCheckFailed

Raises when the encrypted file did not pass the data integrity verification.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

EncryptedFilePasswordCheckFailed

Occurs when the encryption password is empty or invalid.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

EncryptedFilePasswordRequest

Raises when the WorkbookImportOptions.Password property is not set or contains a wrong password.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

InitializeDocument

Occurs before a document is loaded. Handle this event to set initial document settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

InvalidFormatException

Fires when the supplied data could not be recognized as data in the assumed format for import.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ModifiedChanged

Occurs when the value of the Workbook.Modified property is changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

PanesFrozen

Occurs after a worksheet area has been frozen.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

PanesUnfrozen

Occurs after a frozen worksheet area has been unlocked.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

RangeCopied

Occurs after the range content has been copied.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

RangeCopying

Occurs before a cell range is copied in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

RowHeightChanged

Occurs after the row height was changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

RowsInserted

Occurs after new rows have been added to a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

RowsInserting

Occurs before new rows are added to a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

RowsRemoved

Occurs after rows have been deleted from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

RowsRemoving

Occurs before rows are removed from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

SchemaChanged

Occurs when a worksheet or defined name is renamed, inserted or deleted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ScrollPositionChanged

Occurs when the scroll position changes in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

SelectionChanged

Fires when the selection changes in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ShapeInserted

Occurs after a drawing object has been inserted into a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ShapeRemoved

Occurs after a drawing object has been removed from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ShapeRemoving

Occurs before a drawing object is removed from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ShapesCopying

Occurs before a drawing object is copied in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

SheetInserted

Occurs after a new worksheet has been added to a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

SheetRemoved

Occurs after a worksheet has been removed from a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

SheetRemoving

Occurs before a worksheet is removed from a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

SheetRenamed

Occurs after a worksheet has been renamed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

SheetRenaming

Occurs when a worksheet is about to be renamed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

UnitChanged

Fires after a unit of measurement used in the workbook is changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

UnitChanging

Fires before a unit of measurement used within the workbook is changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

ValidateCustomSqlQuery

Allows you to validate a custom SQL query created in the Data Source Wizard.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

See Also