Cell.GetHtmlContent() Method

Gets cell content as a string in HTML format.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

string GetHtmlContent()

VB.NET

Function GetHtmlContent As String

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.

C#

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);
}

VB

Imports DevExpress.Spreadsheet
Imports DevExpress.XtraSpreadsheet.Export
'... 
Using workbook As New Workbook()
    workbook.LoadDocument("Documents\Document.xlsx", DocumentFormat.Xlsx)
    workbook.Calculate()

    Dim worksheet As Worksheet = workbook.Worksheets(0)
    Dim cell As Cell = worksheet(3, 1) 'B2
    Dim htmlContentString As String = cell.GetHtmlContent(htmlExportOptions)
End Using

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>