Writing a rich string with multiple fonts in one cell

This example shows how to use RichString class. See the result in the richString.xlsx file. 



#include "libxl.h"

using namespace libxl;

int main()
{
    Book* book = xlCreateXMLBook();

    Sheet* sheet = book->addSheet(L"my");

    RichString* rs = book->addRichString();

    Font* font1 = rs->addFont();    
    font1->setColor(COLOR_RED);
    font1->setSize(24);

    Font* font2 = rs->addFont();
    font2->setSize(24);
        
    Font* font3 = rs->addFont();
    font3->setColor(COLOR_BLUE);
    font3->setSize(24);

    Font* font4 = rs->addFont();
    font4->setColor(COLOR_GREEN);
    font4->setSize(24);

    Font* font5 = rs->addFont();
    font5->setScript(SCRIPT_SUPER);
    font5->setSize(24);

    rs->addText(L"E", font1);
    rs->addText(L"=", font2);
    rs->addText(L"m", font3);
    rs->addText(L"c", font4);
    rs->addText(L"2", font5);   

    sheet->writeRichStr(5, 3, rs);

    book->save(L"richString.xlsx");

    book->release();
    
    return 0;
}
Home Documentation Writing Reading Pictures1 Pictures2 Formulas Date/Time SheetByName Merging Grouping InsertRowCol 
NumFormats Formats Fonts Buffer1 Buffer2 Copying TopNFilter Sorting StringFilter NumberFilter FilterByValues Protection 
Replacing RichString BeginWith ColorScale OpRule AltRows