QT Change color of cell content in excel

Question

How to change color of a cell content in an excel sheet in QT? I know we can change background of a cell , change font of cell contents, change style of cell content.

For ex : QAxObject *fontproperty = cells->querysubobject("Font"); fontproperty->setproperty("Bold",true);

What should be the parameters for changing text color in a cell?

Shouldn't you use `Font.Color` property? The value should be an RGB value. See https://msdn.microsoft.com/en-us/vba/excel-vba/articles/font-color-property-excel . — vahancho, Feb 05 '18 at 08:06

score 1 · Answer 1 · answered Apr 22 '18 at 20:53

To change the text color of a cell content in an excel sheet, you should use the property "Color" followed by the QColor parameter that provides colors based on RGB, HSV or CMYK values, as shown in the last line of this code :

QAxObject *cell = sheet->querySubObject("Cells(int,int)", 1, 1);   
cell->setProperty("Value", value);
QAxObject* chars = cell->querySubObject("Characters(int, int)", 1, value.size());
QAxObject* font = chars->querySubObject("Font");
font->setProperty("Color", QColor(0, 176, 80)); //int r, int g, int b

QT Change color of cell content in excel

1 Answers1