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