Skip to main content
All docs
V25.1
  • Row

    Cell.GetHtmlContent() Method

    Gets cell content as a string in HTML format.

    Namespace: DevExpress.Spreadsheet

    Assembly: DevExpress.Spreadsheet.v25.1.Core.dll

    NuGet Package: DevExpress.Spreadsheet.Core

    Declaration

    string GetHtmlContent()

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

    Spreadsheet - Rich Text

    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