Created attachment 25167 [details] Example file with font and background colors When examining an XLSX file created with Microsoft Excel that has both font colors and background colors in it, those colors cannot be extracted because the XSSFColor method always returns null. 1) Open the attached XLSX file (or any XLSX file that has a font color or fill color) 2) Navigate the sheet to one of the cells with color 3) Get that cell's style and font and notice that the getXSSFColor() method returns non-null XSSFColor 4) Call getRgb() on the XSSFColor and receive null value in return An array with the RGB values should be returned. To make this bug more painful, I have been unable to find any workaround.
You can see this: https://issues.apache.org/bugzilla/show_bug.cgi?id=48432
(In reply to comment #1) > You can see this: > https://issues.apache.org/bugzilla/show_bug.cgi?id=48432 But org.openxmlformats.schemas.drawingml.x2006.main.CTColorScheme and ThemeDocument can not found in poi-ooxml-schemas-3.6-20091214.jar
I'd suggest you try un-zipping the problem file, and taking a look at the XML that makes it up. See if you can spot where the colour details are being recorded, then compare that with what POI is doing to spot where the issue comes from
(In reply to comment #3) > I'd suggest you try un-zipping the problem file, and taking a look at the XML > that makes it up. See if you can spot where the colour details are being > recorded, then compare that with what POI is doing to spot where the issue > comes from Ok,Where I can download poi-ooxml-schemas-3.6-20091214.jar corresponding source code? So I add new ThemeDocument and CTColorScheme Class into poi-ooxml-schemas-3.6 project.Thank you very much!
It's an auto-generated jar, based on the microsoft XSDs. See the list archive for many discussions on how to get the generated source.
I think this is on-purpose because the color is "indexed", i.e. one of a predefined set provided by Excel. See methods isRGB() and getIndex() in XSSFColor, if isRGB() returns false, getRGB() will return null.
Also note that if you want the hex value, whether indexed or normal, then there's https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/ExtendedColor.html#getARGBHex%28%29 (works for XSSFColor amongst others)