Back to Devexpress

Workbook Methods

officefileapi-devexpress-dot-spreadsheet-dot-workbook-dot-underscore-methods.md

latest100.2 KB
Original Source

Workbook Methods

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

NameDescription
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.

|

See Also

Workbook Class

Workbook Members

DevExpress.Spreadsheet Namespace