Excel |
Current Excel objects (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.2.0.0+da7797057e6d5ef3b02633ee3e36991921c726cb
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| Name | Description | |
|---|---|---|
 | CurrentCell | Cell at the current row and column |
| Report | Current report |
Methods| Name | Description | |
|---|---|---|
| AddPicture | Insert a picture at the current position of the current worksheet and move the current row below it. If a width in pixels is given, the picture is resized with its proportions kept. |
| AddWorksheet | Add a Worksheet to the current Workbook |
| ApplyStyle(IXLCell, String) | Apply one of the standard Seal styles to a cell |
| ApplyStyle(IXLRange, String) | Apply one of the standard Seal styles to a range |
| ApplyStyle(IXLStyle, String) | Apply one of the standard Seal styles (value, title or total) to a style object. ClosedXML has no named styles, so the attributes are set directly on the cell or the range. |
| CleanWorkbook | Clean the current Workbook |
| CloseHeadlessBrowser | Close the headless browser if it has been opened |
| 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) |
| GetHtmlElementPicture | Returns the picture (PNG) of an element of the HTML result of the report (e.g. a map or a gauge). The HTML result is only generated if a view requires it (refer to ReportExecution.checkHTMLPrintResult), null is returned otherwise. |
 | GetPageOrientation | Returns the ClosedXML page orientation matching a name |
| GetPaperSize | Returns the ClosedXML paper size matching a name. The names of the EPPlus 'ePaperSize' enumeration stored in existing reports (e.g. 'A4', 'Letter') are mapped to their ClosedXML equivalent ('A4Paper', 'LetterPaper'). |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| SetHtmlValue(IXLCell, String) | Converts an HTML string to plain text and writes it into a cell. The cell WrapText / alignment / merge must be set by the caller. |
| SetHtmlValue(IXLRange, String) | Converts an HTML string to plain text and writes it into the first cell of a range (e.g. a merged range). The range WrapText / alignment / merge must be set by the caller. |
| SetValue(ResultCell, Boolean, Boolean) | Set a ResultCell value at the current row and column |
| SetValue(IXLCell, ResultCell, Boolean, Boolean) | Set a ResultCell value in an Excel cell |
| SetValue(IXLRange, ResultCell, Boolean, Boolean) | Set a ResultCell value in the first cell of a range (e.g. a merged range) |
| 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 |
| HeadlessBrowser | Headless browser showing the HTML result of the report, opened at the first picture got with GetHtmlElementPicture() |
| Workbook | Current ClosedXML workbook generating the result file |
| Worksheet | Current worksheet being generated |
See Also