Getting color in RGB

Feature requests
1

Hi,

Used for analyzing Excel files.
Some cell colors can’t be retrieved.
Would rather get RGB values than constants.

Best regards,

2

Hello Hayami,

it’s possible.

Please add the following line to your code:

book->setRgbMode(true);

Now you can extract the RGB value with the Book::colorUnpack() method:

book->colorUnpack(color, &red, &green, &blue);

I hope this helps.

3

Done.

wBook.colorUnpack(wSheet.cellFormat(1, 1).patternForegroundColor, r, g, b);

Thank you very much.

1 Like