The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

IWorkbook Methods

Exposes the specific functionality of a workbook.

Name Description
AcceptChanges() If implemented by a class, applies all changes made by the Property editor when implemented by a class.
(Inherited from IPrintable)
Calculate()

Forces recalculation of the workbook.

Calculate(CellRange)

Forces recalculation of the specified cell range in a worksheet.

Calculate(Worksheet)

Forces recalculation of the specified worksheet in a workbook.

CalculateFull()

Forces a full calculation of the data in a workbook.

CalculateFullRebuild()

Forces a full calculation of cell formulas in a workbook.

CreateArea(String, IBrickGraphics) When implemented by a class, creates report elements (bricks) for a specific area.
(Inherited from IBasePrintable)
CreateNewDocument()

Creates and loads a new empty workbook.

(Inherited from ISpreadsheetComponent)
Dispose() Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
(Inherited from IDisposable)
Evaluate(String)

Evaluates the specified formula.

Evaluate(String, FormulaEvaluationContext)

Evaluates the specified formula in a certain context.

ExportToHtml(Stream, CellRange)

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

ExportToHtml(Stream, HtmlDocumentExporterOptions)

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

ExportToHtml(Stream, Int32)

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

ExportToHtml(Stream, Worksheet)

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

ExportToHtml(String, CellRange)

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

ExportToHtml(String, HtmlDocumentExporterOptions)

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

ExportToHtml(String, Int32)

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

ExportToHtml(String, Worksheet)

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

ExportToPdf(Stream)

Exports the workbook to the specified stream in PDF format.

ExportToPdf(Stream, PdfExportOptions)

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

ExportToPdf(String)

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

ExportToPdf(String, PdfExportOptions)

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

If implemented by a class, finalizes the printing of the report.
(Inherited from IBasePrintable)
GenerateMailMergeDocuments()

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

GetService(Type) Gets the service object of the specified type.
(Inherited from IServiceProvider)
HasPropertyEditor() If implemented by a class, determines whether the class provides the Property editor form.
(Inherited from IPrintable)
When implemented by a class, initializes a control for report creation.
(Inherited from IBasePrintable)
LoadDocument(Byte[])

Loads the document from a Byte[] array.

(Inherited from ISpreadsheetComponent)
LoadDocument(Byte[], DocumentFormat)

Loads a document from a byte array.

(Inherited from ISpreadsheetComponent)
LoadDocument(Stream)

Loads the document from a stream.

(Inherited from ISpreadsheetComponent)
LoadDocument(Stream, DocumentFormat)

Loads a document from a stream, specifying the document format.

(Inherited from ISpreadsheetComponent)
LoadDocument(String)

Loads a document from a file.

(Inherited from ISpreadsheetComponent)
LoadDocument(String, DocumentFormat)

Loads a document from a file, specifying the document format.

(Inherited from ISpreadsheetComponent)
Protect(String, Boolean, Boolean)

Protects the structure and windows of a workbook.

RejectChanges() If implemented by a class, cancels changes made by a user in the Property editor when implemented by a class.
(Inherited from IPrintable)
SaveDocument(DocumentFormat)

Saves a document to an array of bytes in the specified format.

(Inherited from ISpreadsheetComponent)
SaveDocument(DocumentFormat, EncryptionSettings)

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

(Inherited from ISpreadsheetComponent)
SaveDocument(Stream, DocumentFormat)

Saves the document to a stream, specifying the document format.

(Inherited from ISpreadsheetComponent)
SaveDocument(Stream, DocumentFormat, EncryptionSettings)

Saves the document to a stream, specifying the document format anf encryption options.

(Inherited from ISpreadsheetComponent)
SaveDocument(String)

Saves the document to the specified file. The file format is identified by the file extension.

(Inherited from ISpreadsheetComponent)
SaveDocument(String, DocumentFormat)

Saves the document to a file, specifying the document format.

(Inherited from ISpreadsheetComponent)
SaveDocument(String, DocumentFormat, EncryptionSettings)

Saves the document to a file, specifying the document format and encryption options.

(Inherited from ISpreadsheetComponent)
SaveDocument(String, EncryptionSettings)

Saves the document to the specified file with the specified encryption options. The file format is identified by the file extension.

(Inherited from ISpreadsheetComponent)
Search(String)

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

Search(String, SearchOptions)

Performs a search in the current document using specified options.

ShowHelp() If implemented by a class, invokes the help system for the Property editor when implemented by a class.
(Inherited from IPrintable)
SupportsHelp() If implemented by a class, determines whether the help system is available for the Property editor when implemented by a class .
(Inherited from IPrintable)
Unprotect(String)

Removes protection from a workbook.

See Also