Cell.GetHtmlContent() Method
Gets cell content as a string in HTML format.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Returns
Type | Description |
---|---|
String | The string that contains cell content in HTML format. |
Remarks
Use the GetHtmlContent
method to export cell content to HTML and obtain the result as a string.
Example
The following snippet loads a document from a file and exports content from cell B2. The cell contains rich-formatted text with 3 text runs.
using DevExpress.Spreadsheet;
using DevExpress.XtraSpreadsheet.Export;
//...
using (Workbook workbook = new Workbook()) {
workbook.LoadDocument("Documents\\Document.xlsx", DocumentFormat.Xlsx);
workbook.Calculate();
Worksheet worksheet = workbook.Worksheets[0];
Cell cell = worksheet[3, 1]; //B2
string htmlContentString = cell.GetHtmlContent(htmlExportOptions);
}
The resulting HTML string looks as follows:
<font style="font-family:Arial;font-size:14pt;font-weight:normal;font-style:normal;color:#C59FC9;">Rich </font>
<font style="font-family:Tahoma;font-size:14pt;font-weight:normal;font-style:normal;color:#2C608E;">text </font>
<font style="font-family:Castellar;font-size:14pt;font-weight:normal;font-style:normal;color:#2F244F;">formatting</font>
See Also