IWorkbook Methods
A workbook loaded into the Spreadsheet control (for WinForms, WPF, and ASP.NET).Name | Description |
---|---|
Add |
Adds the specified service to the service container, and optionally promotes the service to parent service containers.
Inherited from IService |
Add |
Adds the specified service to the service container.
Inherited from IService |
Add |
Adds the specified service to the service container, and optionally promotes the service to any parent service containers.
Inherited from IService |
Add |
Adds the specified service to the service container.
Inherited from IService |
Calculate() | Forces recalculation of the workbook. |
Calculate |
Forces recalculation of the specified cell range in a worksheet. |
Calculate |
Forces recalculation of the specified worksheet in a workbook. |
Calculate |
Forces a full calculation of the data in a workbook. |
Calculate |
Forces a full calculation of cell formulas in a workbook. |
Create |
When implemented by a class, creates report elements (bricks) for a specific area.
Inherited from IBase |
Create |
Creates and loads a new empty workbook.
Inherited from ISpreadsheet |
Dispose() | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. Inherited from IDisposable. |
Evaluate |
Evaluates the specified formula in a certain context. |
Evaluate |
Evaluates the specified formula. |
Export |
Exports the specified range to the specified stream in HTML format. |
Export |
Exports the specified worksheet to the specified stream in HTML format. |
Export |
Exports the document’s data to the specified stream in HTML format using the specified options. |
Export |
Exports the specified worksheet to the specified stream in HTML format. |
Export |
Exports the specified range to the specified file in HTML format. |
Export |
Exports the specified worksheet to the specified file in HTML format. |
Export |
Exports the document’s data to the specified file in HTML format using the specified options. |
Export |
Exports the specified worksheet to the specified file in HTML format. |
Export |
Exports the workbook to the specified stream in PDF format using the specified options. |
Export |
Exports the workbook to the specified stream in PDF format. |
Export |
Exports the workbook to the specified file path in PDF format using the specified options. |
Export |
Exports the workbook to the specified file path in PDF format. |
Finalize |
If implemented by a class, finalizes the printing of the report.
Inherited from IBase |
Generate |
Performs the mail merge and returns the collection of resulting workbooks. |
Get |
Gets the service object of the specified type.
Inherited from IService |
Initialize |
When implemented by a class, initializes a control for report creation.
Inherited from IBase |
Load |
Loads a document from a byte array.
Inherited from ISpreadsheet |
Load |
Loads the document from a Byte[] array.
Inherited from ISpreadsheet |
Load |
Loads a document from a stream, specifying the document format.
Inherited from ISpreadsheet |
Load |
Loads the document from a stream.
Inherited from ISpreadsheet |
Load |
Loads a document from a file, specifying the document format.
Inherited from ISpreadsheet |
Load |
Loads a document from a file.
Inherited from ISpreadsheet |
Protect |
Protects the structure and windows of a workbook. |
Remove |
Removes the specified service type from the service container, and optionally promotes the service to parent service containers.
Inherited from IService |
Remove |
Removes the specified service type from the service container.
Inherited from IService |
Save |
Saves a document to an array of bytes in the specified format with the specified encryption settings.
Inherited from ISpreadsheet |
Save |
Saves a document to an array of bytes in the specified format.
Inherited from ISpreadsheet |
Save |
Saves the document to a stream, specifying the document format anf encryption options.
Inherited from ISpreadsheet |
Save |
Saves the document to a stream, specifying the document format.
Inherited from ISpreadsheet |
Save |
Saves the document to a file, specifying the document format and encryption options.
Inherited from ISpreadsheet |
Save |
Saves the document to a file, specifying the document format.
Inherited from ISpreadsheet |
Save |
Saves the document to the specified file with the specified encryption options. The file format is identified by the file extension.
Inherited from ISpreadsheet |
Save |
Saves the document to the specified file. The file format is identified by the file extension.
Inherited from ISpreadsheet |
Search |
Performs a search in the current document using specified options. |
Search |
Performs a search in the current document using the default parameters. |
Unprotect |
Removes protection from a workbook. |
See Also