how to get font color of a XSSF CELLSTYLE?

Question

I am trying to get font color of cell of a XLSX file. I am using the apache poi. I am able to get the cell color but not the font color. Any kind of suggestion will be appreciated.

thanks

Answer 1

From an XSSFCellStyle you can get the XSSFFont. From that, you can get the XSSFColor. Finally, from the XSSFColor, you can get the colour information as ARGB Hex, RGB with Tint etc.

Your code would look something like:

XSSFCellStyle style = cell.getCellStyle();
XSSFFont font = style.getFont();
XSSFColor colour = font.getXSSFColour();
System.out.println("The colour is " + colour.getARGBHex());