Access and Update the Portions of Rich Text of Cell with C++

Aspose.Cells allows you to access and update the portions of the rich text of the cell. For this purpose, you can use Cell->GetCharacters() and Cell->SetCharacters() methods. These methods will return and accept the array of FontSetting objects which you can use to access and update various properties of font like font name, font color, boldness, etc.

Access and Update the Portions of Rich Text of Cell

The following code demonstrates the usage of Cell->GetCharacters() and Cell->SetCharacters() method using the source excel file. The source excel file has a rich text in cell A1 with 3 portions, each having a different font. The code accesses these portions and updates the first portion’s font to “Arial”. The modified workbook is saved as output excel file.

C++ code to access and update rich text portions

#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;

int main()
{
    Aspose::Cells::Startup();

    U16String srcDir(u"..\\Data\\01_SourceDirectory\\");
    U16String outDir(u"..\\Data\\02_OutputDirectory\\");

    U16String inputPath = srcDir + u"Sample.xlsx";
    U16String outputPath = outDir + u"Output.out.xlsx";

    Workbook workbook(inputPath);

    Worksheet worksheet = workbook.GetWorksheets().Get(0);

    Cell cell = worksheet.GetCells().Get(U16String(u"A1"));

    std::cout << "Before updating the font settings...." << std::endl;

    Vector<FontSetting> fnts = cell.GetCharacters();

    for (int i = 0; i < fnts.GetLength(); ++i)
    {
        FontSetting& fs = fnts[i];
        std::cout << fs.GetFont().GetName().ToUtf8() << std::endl;
    }

    if (fnts.GetLength() > 0)
    {
        FontSetting& fs = fnts[0];
        fs.GetFont().SetName(u"Arial");
        cell.SetCharacters(fnts);
    }

    std::cout << std::endl << "After updating the font settings...." << std::endl;

    fnts = cell.GetCharacters();

    for (int i = 0; i < fnts.GetLength(); ++i)
    {
        FontSetting& fs = fnts[i];
        std::cout << fs.GetFont().GetName().ToUtf8() << std::endl;
    }

    workbook.Save(outputPath);

    Aspose::Cells::Cleanup();
    return 0;
}

Console output generated by the sample code

Here is the console output when using the source excel file:

Before updating the font settings....
Century
Courier New
Verdana

After updating the font settings....
Arial
Courier New
Verdana