/** * @see HSSFColor#getHexString() */ public String getHexString() { return color.getHexString(); }
/** * @see HSSFColor#getHexString() */ public String getHexString() { return color.getHexString(); }
private static String renderColor(Color color) { if(color instanceof HSSFColor) { return ((HSSFColor)color).getHexString(); } else if(color instanceof XSSFColor) { return ((XSSFColor)color).getARGBHex(); } else { return "(none)"; } } }
public static String toBackgroundColor(HSSFColor hssfColor, boolean whiteAsTransparent) { if (hssfColor == null) { return ""; } if (whiteAsTransparent && WHITE.hexString.equals(hssfColor.getHexString())) { return ""; } return String.format("background-color:%s;", StyleColorUtil.toHexColor(hssfColor)); }
private static Hashtable<String,HSSFColor> createColorsByHexStringMap() { HSSFColor[] colors = getAllColors(); Hashtable<String,HSSFColor> result = new Hashtable<String,HSSFColor>(colors.length * 3 / 2); for (int i = 0; i < colors.length; i++) { HSSFColor color = colors[i]; String hexString = color.getHexString(); if (result.containsKey(hexString)) { HSSFColor other = (HSSFColor)result.get(hexString); throw new RuntimeException( "Dup color hexString (" + hexString + ") for color (" + color.getClass().getName() + ") - " + " already taken by (" + other.getClass().getName() + ")" ); } result.put(hexString, color); } return result; }
private static Hashtable<String,HSSFColor> createColorsByHexStringMap() { HSSFColor[] colors = getAllColors(); Hashtable<String,HSSFColor> result = new Hashtable<String,HSSFColor>(colors.length * 3 / 2); for (int i = 0; i < colors.length; i++) { HSSFColor color = colors[i]; String hexString = color.getHexString(); if (result.containsKey(hexString)) { HSSFColor other = (HSSFColor)result.get(hexString); throw new RuntimeException( "Dup color hexString (" + hexString + ") for color (" + color.getClass().getName() + ") - " + " already taken by (" + other.getClass().getName() + ")" ); } result.put(hexString, color); } return result; }
public short getNearestColor( final Color awtColor ) { if ( lastUsedColor > 64 ) { // we ran out of palette... try to get nearest color then return StaticExcelColorSupport.getNearestColor( awtColor, usedTripplets ); } final HSSFPalette palette = workbook.getCustomPalette(); final HSSFColor hssfColor = palette.findColor( (byte) awtColor.getRed(), (byte) awtColor.getGreen(), (byte) awtColor.getBlue() ); if ( hssfColor != null && hssfColor.getIndex() < lastUsedColor ) { return hssfColor.getIndex(); } else { palette.setColorAtIndex( lastUsedColor, (byte) awtColor.getRed(), (byte) awtColor.getGreen(), (byte) awtColor .getBlue() ); final HSSFColor color = palette.getColor( lastUsedColor ); usedTripplets.put( color.getHexString(), color ); return lastUsedColor++; } }
HSSFColor hssfCellColor = (HSSFColor) cellColor; System.out.println(hssfCellColor.getHexString()); if(hssfCellColor.getHexString().equals("0:FFFF:0")) { System.out.println(cell.getAddress() + " is green"); } else if(hssfCellColor.getHexString().equals("FFFF:FFFF:0")) { System.out.println(cell.getAddress() + " is yellow");
public void testMapping() { System.out.println( "0xC6=" + 0xC6 ); final Color c = new Color( 0xC6C3C6 ); final StaticExcelColorSupport colorSupport = new StaticExcelColorSupport(); final short nearestColor = colorSupport.getNearestColor( c ); assertEquals( "Color: " + c + " -> " + colorSupport.getColor( nearestColor ).getHexString(), 22, nearestColor ); }