Excel |
The ExcelResult type exposes the following members.
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) |
See Also