Excel |
Current Excel objects (package, workbook, worksheet and current position) shared by the Excel renderer templates during the report execution. The instance is available from the report with Report.ExcelResult.
Inheritance HierarchyNamespace: Seal.Renderer
Assembly: SealLibrary (in SealLibrary.dll) Version: 10.0.1.0+a44cd3a7f03c2bf3cdbd971a878c679e40bed08a
SyntaxC#
public class ExcelResult
The ExcelResult type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | ExcelResult | Creates the Excel result and assigns it to the report |
Properties
Methods| Name | Description | |
|---|---|---|
| AddWorksheet | Add a Worksheet to the current Workbook |
| CleanWorkbook | Clean the current Workbook |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| SetHtmlValue | Converts an HTML string to plain text and writes it into an EPPlus cell. The cell's WrapText / alignment / merge must be set by the caller. |
| SetValue(ResultCell, Boolean, Boolean) | Set a ResultCell value at the current row and column |
| SetValue(ExcelRange, ResultCell, Boolean, Boolean) | Set a ResultCell value in an Excel cell |
| SetValue(Int32, Int32, ResultCell, Boolean, Boolean) | Set a ResultCell value at a given row and column |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
Fields| Name | Description | |
|---|---|---|
  | CellTitleStyle | Name of the style applied to a title cell |
| CellValueStyle | Name of the style applied to a standard cell value |
| CellValueTotalStyle | Name of the style applied to a total cell value |
| CurrentCol | Current column index in the worksheet, starting at 1 |
| CurrentRow | Current row index in the worksheet, starting at 1 |
| Package | Current EPPlus package generating the result file |
| Workbook | Current workbook of the package |
| Worksheet | Current worksheet being generated |
See Also