Java HSSFColor.getTriplet方法代碼示例

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
/**
 * 創建顏色。
 * 
 * 寫本方法的原因是：從2003版本的模板中複製單元格顏色時，會出現顏色失真的問題。
 * 
 * 但最終也沒有解決。因為：當單元格的顏色設置為非標準顏色時，就會失真，但設置為標準顏色時，是正常的。
 * 
 * 也因為此，本方法與 i_ToCellStyle.setFillBackgroundColor(i_FromCellStyle.getFillBackgroundColor()); 的效果是相同的。
 * 
 * 本方法作為研究使用而保留下來，但不沒有使用價值。
 * 
 * @author      ZhengWei(HY)
 * @createDate  2017-03-21
 * @version     v1.0
 *
 * @param i_FromColor
 * @param i_DataWorkbook
 * @return
 */
@Deprecated
public final static HSSFColor createColor(HSSFColor i_FromColor ,HSSFWorkbook i_DataWorkbook)
{
    short [] v_RGBHex    = i_FromColor.getTriplet();
    byte     v_ByteRed   = (byte)v_RGBHex[0];
    byte     v_ByteGreen = (byte)v_RGBHex[1];
    byte     v_ByteBlue  = (byte)v_RGBHex[2];
    
    HSSFPalette v_Palette   = i_DataWorkbook.getCustomPalette();
    HSSFColor   v_DataColor = v_Palette.findColor(v_ByteRed ,v_ByteGreen ,v_ByteBlue);
    
    if ( v_DataColor == null )
    {
        v_Palette.setColorAtIndex(i_FromColor.getIndex() ,v_ByteRed ,v_ByteGreen ,v_ByteBlue);
        
        return v_Palette.getColor(i_FromColor.getIndex());
    }
    
    return  v_DataColor;
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
/**
 * 單元格背景色轉換
 */
private String convertToStardColor(HSSFColor hc) {
	StringBuffer sb = new StringBuffer("");
	if (hc != null) {
		int a = HSSFColor.AUTOMATIC.index;
		int b = hc.getIndex();
		if (a == b) {
			return null;
		}
		sb.append("#");
		for (int i = 0; i < hc.getTriplet().length; i++) {
			String str;
			String strTmp = Integer.toHexString(hc.getTriplet()[i]);
			if (strTmp != null && strTmp.length() < 2) {
				str = "0" + strTmp;
			} else {
				str = strTmp;
			}
			sb.append(str);
		}
	}
	return sb.toString();
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
/**
 * Test converting color from Meja to POI color and back again does not
 * change the color value.
 *
 * This test checks the implementation for HSSF.
 */
@Test
public void testColorConversionHssf() {
    PoiWorkbook.PoiHssfWorkbook wb = (PoiWorkbook.PoiHssfWorkbook) PoiWorkbookFactory.instance().createXls();
    // HSSF maps colors to more or less matching nearest colors.
    Set<String> used = new HashSet<>();
    for (Color col : Color.values()) {
        HSSFColor poiColor = wb.getPoiColor(col);
        short[] t = poiColor.getTriplet();
        Color expected = new Color(t[0], t[1], t[2]);
        Color actual = wb.getColor(poiColor, Color.BLACK);
        assertEquals(expected, actual);
        used.add(expected.toString());
    }
    assertTrue(used.size()>20);
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
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 {
        short[] rgb = color.getTriplet();
        out.format("  %s: #%02x%02x%02x; /* index = %d */%n", attr, rgb[0], rgb[1], rgb[2],
            index);
    }
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
public static int getRGB(Color color) {
	if (color == null) {
		return -1;
	}

	int[] rgb = new int[3];
	if (color instanceof HSSFColor) {
		HSSFColor hssf = (HSSFColor) color;
		short[] s = hssf.getTriplet();
		rgb[0] = s[0] & 0xff;
		rgb[1] = s[1] & 0xff;
		rgb[2] = s[2] & 0xff;
	} else if (color instanceof XSSFColor) {
		XSSFColor xssf = (XSSFColor) color;
		byte[] b = xssf.getRGB();
		if (b == null) {
			return -1;
		}
		rgb[0] = b[0] & 0xff;
		rgb[1] = b[1] & 0xff;
		rgb[2] = b[2] & 0xff;
	} else {
		throw new IllegalStateException(MessageFormat.format("unsupported POI color={0}", color));
	}

	return (rgb[0] << 16) | (rgb[1] << 8) | rgb[2];
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
/**
 * Get the hex string for a <code>HSSFColor</code>.  Moved from test code.
 * @param hssfColor A <code>HSSFColor</code>.
 * @return The hex string.
 * @since 0.5.0
 */
private static String getHSSFColorHexString(HSSFColor hssfColor)
{
   short[] shorts = hssfColor.getTriplet();
   StringBuilder hexString = new StringBuilder();
   for (short s : shorts)
   {
      String twoHex = Integer.toHexString(0x000000FF & s);
      if (twoHex.length() == 1)
         hexString.append('0');
      hexString.append(twoHex);
   }
   return hexString.toString();
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
public static String getColor( HSSFColor color )
{
    StringBuilder stringBuilder = new StringBuilder( 7 );
    stringBuilder.append( '#' );
    for ( short s : color.getTriplet() )
    {
        if ( s < 10 )
            stringBuilder.append( '0' );

        stringBuilder.append( Integer.toHexString( s ) );
    }
    String result = stringBuilder.toString();

    if ( result.equals( "#ffffff" ) )
        return "white";

    if ( result.equals( "#c0c0c0" ) )
        return "silver";

    if ( result.equals( "#808080" ) )
        return "gray";

    if ( result.equals( "#000000" ) )
        return "black";

    return result;
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
/**
 * Converts a POI color to an AWT color.
 */
public static Color shortToColor(short xlsColorIndex) {
    if (xlsColorIndex > 0) {
        HSSFColor xlsColor = HSSFColor.getIndexHash().get(new Integer(xlsColorIndex));
        if (xlsColor != null) {
            short[] rgb = xlsColor.getTriplet();
            return new Color(rgb[0], rgb[1], rgb[2]);
            //return Color.decode(xlsColor.getHexString());
        }
    }
    return null;
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
private static Color getColor(org.apache.poi.ss.usermodel.Color c) {
	if (c == null) {
		return null;
	} else if (c instanceof HSSFColor) {
		HSSFColor hc = (HSSFColor)c;
		short[] rgb = hc.getTriplet();
		return new Color(rgb[0], rgb[1], rgb[2]);
	} else if (c instanceof XSSFColor) {
		XSSFColor xc = (XSSFColor)c;
		byte[] data = null;
		if (xc.getTint() != 0.0) {
			data = getRgbWithTint(xc);
			byte[] argb = xc.getARgb();
		} else {
			data = xc.getARgb();
		}
		if (data == null) {
			return null;
		}
		int idx = 0;
		int alpha = 255;
		if (data.length == 4) {
			alpha = data[idx++] & 0xFF;
		}
		int r = data[idx++] & 0xFF;
		int g = data[idx++] & 0xFF;
		int b = data[idx++] & 0xFF;
		return new Color(r, g, b, alpha);
	} else {
		throw new IllegalStateException();
	}
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
public static String toHexColor(HSSFColor hssfColor) {
    short[] rgb = hssfColor.getTriplet();
    return String.format("#%02X%02X%02X", rgb[0], rgb[1], rgb[2]);
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
public static byte[] toRgbByte(HSSFColor hssfColor) {
    short[] rgb = hssfColor.getTriplet();
    return new byte[] { (byte)rgb[0], (byte)rgb[1], (byte)rgb[2] };
}
 

import org.apache.poi.hssf.util.HSSFColor; //導入方法依賴的package包/類
/**
 * Find a suitable color for the cell.
 * <p/>
 * The algorithm searches all available triplets, weighted by tripletvalue and
 * tripletdifference to the other triplets. The color wins, which has the
 * smallest triplet difference and where all triplets are nearest to the
 * requested color.
 *
 * @param awtColor the awt color that should be transformed into an Excel color.
 * @return the excel color index that is nearest to the supplied color.
 */
public static synchronized short getNearestColor(
        final Color awtColor) {
    if (triplets == null) {
        triplets = HSSFColor.getTripletHash();
    }

    if (triplets == null || triplets.isEmpty()) {
        System.out.println("Unable to get triplet hashtable");
        return HSSFColor.BLACK.index;
    }

    short color = HSSFColor.BLACK.index;
    double minDiff = Double.MAX_VALUE;

    // get the color without the alpha chanel
    final float[] hsb = Color.RGBtoHSB(awtColor.getRed(), awtColor
            .getGreen(), awtColor.getBlue(), null);

    float[] excelHsb = null;
    final Iterator elements = triplets.values().iterator();
    while (elements.hasNext()) {
        final HSSFColor crtColor = (HSSFColor) elements.next();
        final short[] rgb = crtColor.getTriplet();
        excelHsb = Color.RGBtoHSB(rgb[0], rgb[1], rgb[2], excelHsb);

        final double weight = 3.0d * Math.abs(excelHsb[0] - hsb[0])
                + Math.abs(excelHsb[1] - hsb[1])
                + Math.abs(excelHsb[2] - hsb[2]);

        if (weight < minDiff) {
            minDiff = weight;
            if (minDiff == 0) {
                // we found the color ...
                return crtColor.getIndex();
            }
            color = crtColor.getIndex();
        }
    }
    return color;
}