List of usage examples for org.apache.poi.hssf.util HSSFColor getTriplet
public short[] getTriplet()
From source file:br.com.tecsinapse.dataio.style.StyleColorUtil.java
License:LGPL
public static String toHexColor(HSSFColor hssfColor) { short[] rgb = hssfColor.getTriplet(); return String.format("#%02X%02X%02X", rgb[0], rgb[1], rgb[2]); }
From source file:br.com.tecsinapse.dataio.util.WorkbookUtil.java
License:LGPL
public static byte[] toRgbByte(HSSFColor hssfColor) { short[] rgb = hssfColor.getTriplet(); return new byte[] { (byte) rgb[0], (byte) rgb[1], (byte) rgb[2] }; }
From source file:br.com.tecsinapse.dataio.util.WorkbookUtil.java
License:LGPL
public static Color toAwtColor(final HSSFColor hssfColor) { short[] rgb = hssfColor.getTriplet(); return new Color(rgb[0], rgb[1], rgb[2]); }
From source file:cc.landking.converter.office.excel.HSSFHtmlHelper.java
License:Apache License
private void styleColor(Formatter out, String attr, short index) { HSSFColor color = colors.getColor(index); if (index == HSSF_AUTO.getIndex() || color == null) { out.format(" /* %s: index = %d */%n", attr, index); } else {//from ww w .j av a 2 s. c o m short[] rgb = color.getTriplet(); out.format(" %s: #%02x%02x%02x; /* index = %d */%n", attr, rgb[0], rgb[1], rgb[2], index); } }
From source file:cn.trymore.core.util.excel.PoiExcelParser.java
License:Open Source License
private String tripleToRGBString(short color) { HSSFColor colour = getHSSFColor(color); StringBuilder sb = new StringBuilder(); if (colour != null) { int i = 0; for (int len = colour.getTriplet().length; i < len; ++i) { short t = colour.getTriplet()[i]; if (i < len - 1) sb.append(new StringBuilder().append(t).append(",").toString()); else { sb.append(t);/*from w w w. j ava 2 s.c om*/ } } return new StringBuilder().append("rgb(").append(sb.toString()).append(")").toString(); } return null; }
From source file:com.canoo.webtest.plugins.exceltest.ExcelColorUtils.java
License:Open Source License
public static String getColorName(final AbstractExcelStep step, final Color color) { if (color == null) { return "none"; }//from w ww . j av a2s. co m if (color instanceof HSSFColor) { HSSFColor hssfcolor = (HSSFColor) color; if (hssfcolor.getIndex() == AUTOMATIC_COLOR) { return "auto"; } final short[] triplet = hssfcolor.getTriplet(); final String colorString = "#" + toHex(triplet[0]) + toHex(triplet[1]) + toHex(triplet[2]); return lookupStandardColorName(colorString); } else { XSSFColor xssfcolor = (XSSFColor) color; if (xssfcolor.isAuto()) { return "auto"; } final byte[] triplet = xssfcolor.getRgb(); final String colorString = "#" + toHex(triplet[0]) + toHex(triplet[1]) + toHex(triplet[2]); return lookupStandardColorName(colorString); } }
From source file:com.cn.led.Grid.java
private java.awt.Color poiColor2awtColor(org.apache.poi.ss.usermodel.Color color) { java.awt.Color awtColor = null; if (color instanceof XSSFColor) { //.xlsx XSSFColor xc = (XSSFColor) color; String rgbHex = xc.getARGBHex(); if (rgbHex != null) { awtColor = new Color(Integer.parseInt(rgbHex.substring(2), 16)); }// w ww. j a v a 2 s .c o m } else if (color instanceof HSSFColor) { //.xls HSSFColor hc = (HSSFColor) color; short[] s = hc.getTriplet(); if (s != null) { awtColor = new Color(s[0], s[1], s[2]); } } return awtColor; }
From source file:com.develog.utils.report.engine.export.JRXlsExporter.java
License:Open Source License
/** * *//*from w w w. j a va 2 s . c o m*/ protected static HSSFColor getNearestColor(Color awtColor) { HSSFColor color = null; Map triplets = HSSFColor.getTripletHash(); if (triplets != null) { Collection keys = triplets.keySet(); if (keys != null && keys.size() > 0) { Object key = null; HSSFColor crtColor = null; short[] rgb = null; int diff = 0; int minDiff = 999; for (Iterator it = keys.iterator(); it.hasNext();) { key = it.next(); crtColor = (HSSFColor) triplets.get(key); rgb = crtColor.getTriplet(); diff = Math.abs(rgb[0] - awtColor.getRed()) + Math.abs(rgb[1] - awtColor.getGreen()) + Math.abs(rgb[2] - awtColor.getBlue()); if (diff < minDiff) { minDiff = diff; color = crtColor; } } } } return color; }
From source file:com.eryansky.core.excelTools.ExcelUtils.java
License:Apache License
private static short findColor(short index, HSSFWorkbook srcwb, HSSFWorkbook destwb) { Integer id = new Integer(index); if (HSSFColor.getIndexHash().containsKey(id)) return index; if (index == HSSFColor.AUTOMATIC.index) return index; HSSFColor color = srcwb.getCustomPalette().getColor(index); if (color == null) { return index; }//from ww w. ja v a 2s . c o m HSSFColor ncolor = destwb.getCustomPalette().findColor((byte) color.getTriplet()[0], (byte) color.getTriplet()[1], (byte) color.getTriplet()[2]); if (ncolor != null) return ncolor.getIndex(); destwb.getCustomPalette().setColorAtIndex(index, (byte) color.getTriplet()[0], (byte) color.getTriplet()[1], (byte) color.getTriplet()[2]); return index; }
From source file:com.siteview.ecc.report.xls.JRXlsExporter.java
License:Open Source License
/** * *//*w w w. java2 s . com*/ protected static HSSFColor getNearestColor(Color awtColor) { HSSFColor color = (HSSFColor) hssfColorsCache.get(awtColor); if (color == null) { Map triplets = HSSFColor.getTripletHash(); if (triplets != null) { Collection keys = triplets.keySet(); if (keys != null && keys.size() > 0) { Object key = null; HSSFColor crtColor = null; short[] rgb = null; int diff = 0; int minDiff = 999; for (Iterator it = keys.iterator(); it.hasNext();) { key = it.next(); crtColor = (HSSFColor) triplets.get(key); rgb = crtColor.getTriplet(); diff = Math.abs(rgb[0] - awtColor.getRed()) + Math.abs(rgb[1] - awtColor.getGreen()) + Math.abs(rgb[2] - awtColor.getBlue()); if (diff < minDiff) { minDiff = diff; color = crtColor; } } } } hssfColorsCache.put(awtColor, color); } return color; }