How to set rich text format in cells in C++

/* ---------------------------------------------------------------
 * Tutorial 19
 * 
 * This tutorial shows how to create an Excel file in C++ having
 * multiple sheets. The first sheet is filled with data and the
 * first cell of the second row contains data in rich text format.
 * --------------------------------------------------------------- */

#include "EasyXLS.h"
#include <conio.h>

int main()
{
    printf("Tutorial 19\n----------\n");

    HRESULT hr;

    // Initialize COM
    hr = CoInitialize(0);

    // Use the SUCCEEDED macro and get a pointer to the interface
    if (SUCCEEDED(hr))
    {
        // Create a pointer to the interface that exports Excel files
        EasyXLS::IExcelDocumentPtr workbook;
        hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
                              NULL,
                              CLSCTX_ALL,
                              __uuidof(EasyXLS::IExcelDocument),
                              (void**) &workbook);

        if (SUCCEEDED(hr)){

            // Create two sheets
            workbook->easy_addWorksheet_2("First tab");
            workbook->easy_addWorksheet_2("Second tab");

            // Get the table of data for the first worksheet
            EasyXLS::IExcelWorksheetPtr xlsFirstTab= (EasyXLS::IExcelWorksheetPtr)workbook->easy_getSheetAt(0);
            EasyXLS::IExcelTablePtr xlsFirstTable = xlsFirstTab->easy_getExcelTable();

            // Create the string used to set the RTF in cell
            char* sFormattedValue = (char*)malloc(536*sizeof(char));
            strcpy_s(sFormattedValue, 21, "This is <b>bold</b>.");
            strcpy_s(sFormattedValue, 24, "\nThis is <i>italic</i>.");
            strcpy_s(sFormattedValue, 27, "\nThis is <u>underline</u>.");
            strcpy_s(sFormattedValue, 64, "\nThis is <underline double>double underline</underline double>.");
            strcpy_s(sFormattedValue, 37, "\nThis is <font color=red>red</font>.");
            strcpy_s(sFormattedValue, 50, "\nThis is <font color=rgb(255,0,0)>red</font> too.");
            strcpy_s(sFormattedValue, 56, "\nThis is <font face=\"Arial Black\">Arial Black</font>.");
            strcpy_s(sFormattedValue, 41, "\nThis is <font size=15pt>size 15</font>.");
            strcpy_s(sFormattedValue, 31, "\nThis is <s>strikethrough</s>.");
            strcpy_s(sFormattedValue, 33, "\nThis is <sup>superscript</sup>.");
            strcpy_s(sFormattedValue, 31, "\nThis is <sub>subscript</sub>.");
            strcpy_s(sFormattedValue, 138, "\n<b>This</b> <i>is</i> <font color=red face=\"Arial Black\" size=15pt>"
                                              "<underline double>formatted</underline double></font> <s>text</s>.");

            // Set the rich text value in cell
            xlsFirstTable->easy_getCell(1, 0)->setHTMLValue(sFormattedValue);
            xlsFirstTable->easy_getCell(1, 0)->setDataType(DATATYPE_STRING);
            xlsFirstTable->easy_getCell(1, 0)->setWrap(true);
            xlsFirstTable->easy_getRowAt(1)->setHeight(250);
            xlsFirstTable->easy_getColumnAt(0)->setWidth(250);

            // Export Excel file
            printf("Writing file C:\\Samples\\Tutorial19 - RTF for Excel cells.xlsx.");
            workbook->easy_WriteXLSXFile("C:\\Samples\\Tutorial19 - RTF for Excel cells.xlsx");

            // Confirm export of Excel file
            _bstr_t sError = workbook->easy_getError();
            if (strcmp(sError, "") == 0){
                printf("\nFile successfully created. Press Enter to Exit...");
            }
            else{
                printf("\nError encountered: %s", (LPCSTR)sError); 
            }

            // Dispose memory
            workbook->Dispose();
        }
        else{
            printf("Object is not available!");
        }
    }
    else{
        printf("COM can't be initialized!");
    }

    // Uninitialize COM
    CoUninitialize();

    _getch();
    return 0;
}

/*------------------------------------------------------------------
 | Tutorial 19
 |
 | This tutorial shows how to create an Excel file in C++.NET having
 | multiple sheets. The first sheet is filled with data and the
 | first cell of the second row contains data in rich text format.
 -------------------------------------------------------------------*/

#include <conio.h>
#include <stdio.h>

using namespace System;
using namespace EasyXLS;
using namespace EasyXLS::Constants;

int main()
{
    Console::WriteLine("Tutorial 19\n----------\n");

    // Create an instance of the class that exports Excel files having two sheets
    ExcelDocument ^workbook = gcnew ExcelDocument(2);

    // Set the sheet names
    workbook->easy_getSheetAt(0)->setSheetName("First tab");
    workbook->easy_getSheetAt(1)->setSheetName("Second tab");

    // Get the table of data for the first worksheet
    ExcelWorksheet ^xlsFirstTab = safe_cast<ExcelWorksheet^>(workbook->easy_getSheetAt(0));
    ExcelTable ^xlsFirstTable = xlsFirstTab->easy_getExcelTable();

    // Create the string used to set the RTF in cell
    String ^sFormattedValue = "This is <b>bold</b>.";
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <i>italic</i>.");
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <u>underline</u>.");
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <underline double>double underline");
    sFormattedValue = String::Concat(sFormattedValue ,"</underline double>.");
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <font color=red>red</font>.");
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <font color=rgb(255,0,0)>red</font> too.");
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <font face=\"Arial Black\">Arial Black</font>.");
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <font size=15pt>size 15</font>.");
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <s>strikethrough</s>.");
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <sup>superscript</sup>.");
    sFormattedValue = String::Concat(sFormattedValue ,"\nThis is <sub>subscript</sub>.");
    sFormattedValue = String::Concat(sFormattedValue ,"\n<b>This</b> <i>is</i> ");
    sFormattedValue = String::Concat(sFormattedValue ,"<font color=red face=\"Arial Black\" size=15pt>");
    sFormattedValue = String::Concat(sFormattedValue ,"<underline double>formatted</underline double></font> ");
    sFormattedValue = String::Concat(sFormattedValue ,"<s>text</s>.");

    // Set the rich text value in cell
    xlsFirstTable->easy_getCell(1, 0)->setHTMLValue(sFormattedValue); 
    xlsFirstTable->easy_getCell(1, 0)->setDataType(DataType::STRING);
    xlsFirstTable->easy_getCell(1, 0)->setWrap(true); 
    xlsFirstTable->easy_getRowAt(1)->setHeight(250);
    xlsFirstTable->easy_getColumnAt(0)->setWidth(250);

    // Export Excel file
    Console::WriteLine("Writing file C:\\Samples\\Tutorial19 - RTF for Excel cells.xlsx.");
    workbook->easy_WriteXLSXFile("C:\\Samples\\Tutorial19 - RTF for Excel cells.xlsx");

    // Confirm export of Excel file
    String ^sError = workbook->easy_getError();
    if (sError->Equals(""))
        Console::Write("\nFile successfully created. Press Enter to Exit...");
    else
        Console::Write(String::Concat("\nError encountered: ", sError, "\nPress Enter to Exit..."));

    // Dispose memory
    delete workbook;

    Console::ReadLine();

    return 0;
}