how to translate theme color to an RGB value

[derksen...@gmail.com]

Hi, 

just started to play with openpyxl. I'm trying to get the cell colors for a sheet i'm parsing. I'm fine on the indexed colors, however i struggle to translate the themed colors to an RGB value.

I.e. the color object contains: 

Color(rgb=Values must be of type <type 'basestring'>, indexed=Values must be of type <type 'long'>, auto=Values must be of type <type 'bool'>, theme=6, tint=0.399975585192, type='theme')

And i need to find a way to translate theme and tint to a color.. 

I came across 

https://groups.google.com/forum/#!msg/openpyxl-users/v2FDsbDDTqU/rQWLAXZFkeUJ

which addressed same problem, but the solution there doesn't work anymore in more recent openpyxl. 

Hopefully there's a straightforward way to do this? 

Tx,

-Daniel

[Charlie Clark]

Am .12.2015, 20:47 Uhr, schrieb <derksen...@gmail.com>:

> just started to play with openpyxl. I'm trying to get the cell colors
> for a
> sheet i'm parsing. I'm fine on the indexed colors, however i struggle to
> translate the themed colors to an RGB value.

Struggle you will. This is from the specification:

"""
A zero-based index into the <clrScheme> collection (§20.1.6.2),
referencing a particular <sysClr> or <srgbClr> value expressed in the
Theme part. The possible values for this attribute are defined by the W3C
XML Schema unsignedInt datatype.
"""
Internally openpyxl doesn't use any themes but it does come with a default
one that always gets written. See openpyxl/writer/theme.py for detail. The
workaround suggested by Adam back in 2013 for working with a particular
scheme should basically still work.

Hope that helps.

Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226

[williaml...@gmail.com]

I stumbled upon this issue, as I faced the exact same problem parsing excel files. For all the ones interested, indeed the posted link works, but needs different imports:  Now QName and fromstring need to be imported from openpyxl.xml.functions . Hope this tip will help you.

Bill