Conditional formatting: highlighting cells that begin with the given text

Home Documentation Writing Reading Pictures1 Pictures2 Formulas DateTime SheetByName
Merging Grouping InsertRowCol NumFormats Formats Fonts Buffer1 Buffer2 Copying TopNFilter
Sorting StringFilter NumberFilter FilterByValues Protection Replacing RichString BeginWith
ColorScale OpRule AltRows

Conditional formatting: highlighting cells that begin with the given text

This example defines a conditional format with a bold font and sets conditional formatting for the range B3:B11 for highlighting cells that begin with 'a'.

#include "libxl.h"

using namespace libxl;

int main()
{
    Book* book = xlCreateXMLBook();
    
    Sheet* sheet = book->addSheet(L"my");

    sheet->writeStr(2, 1, L"Poltava");
    sheet->writeStr(3, 1, L"Athens");
    sheet->writeStr(4, 1, L"Thessaloniki");
    sheet->writeStr(5, 1, L"Kalamata");
    sheet->writeStr(6, 1, L"Amsterdam");
    sheet->writeStr(7, 1, L"Alexandroupolis");
    sheet->writeStr(8, 1, L"Kyiv");
    sheet->writeStr(9, 1, L"London");
    sheet->writeStr(10, 1, L"New York");

    ConditionalFormat* cFormat = book->addConditionalFormat();
    cFormat->font()->setBold(true);
    
    ConditionalFormatting* cf = sheet->addConditionalFormatting();
    cf->addRange(2, 10, 1, 1);
    cf->addRule(CFORMAT_BEGINWITH, cFormat, L"a");
   
    book->save(L"out.xlsx");

    book->release();
    
    return 0;
}