Java HSSFPalette类代码示例

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的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.usermodel.HSSFPalette; //导入依赖的package包/类
private HSSFCellStyle createHSSFCellStyle(Workbook wb, int[] bgColor, int[] fontColor, int fontSize) {
	HSSFWorkbook workbook = (HSSFWorkbook) wb;
	HSSFPalette palette = workbook.getCustomPalette();
	
	palette.setColorAtIndex((short) 9, (byte) fontColor[0], (byte) fontColor[1], (byte) fontColor[2]);
	palette.setColorAtIndex((short) 10, (byte) bgColor[0], (byte) bgColor[1], (byte) bgColor[2]);

	HSSFFont titleFont = workbook.createFont();
	titleFont.setCharSet(HSSFFont.DEFAULT_CHARSET);
	titleFont.setFontName("宋体");
	titleFont.setColor((short) 9);
	titleFont.setBold(true); 
	titleFont.setFontHeightInPoints((short) fontSize);

	HSSFCellStyle titleStyle = (HSSFCellStyle) createBorderCellStyle(workbook, true);
	titleStyle.setFont(titleFont);
	titleStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
	titleStyle.setFillForegroundColor((short) 10);
	titleStyle.setAlignment(HorizontalAlignment.CENTER);
	titleStyle.setVerticalAlignment(VerticalAlignment.CENTER);

	return titleStyle;
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
private void replaceColorsPallete(Map<HSSFColor, HSSFColor> colorsReplaceMap, Workbook wb) {
    if (! (wb instanceof HSSFWorkbook)) {
        return;
    }

    HSSFWorkbook hssfWb = (HSSFWorkbook) wb;
    final HSSFPalette customPalette = hssfWb.getCustomPalette();
    for (Entry<HSSFColor, HSSFColor> e : colorsReplaceMap.entrySet()) {
        short[] rgb = e.getValue().getTriplet();
        customPalette.setColorAtIndex(e.getKey().getIndex(),
                (byte)rgb[0],
                (byte)rgb[1],
                (byte)rgb[2]
        );
    }
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
/**
 * parse color
 * @param workBook work book
 * @param color string color
 * @return HSSFColor 
 */
public static HSSFColor parseColor(HSSFWorkbook workBook, String color) {
	HSSFColor poiColor = null;
	if (StringUtils.isNotBlank(color)) {
		Color awtColor = Color.decode(color);
		if (awtColor != null) {
			int r = awtColor.getRed();
			int g = awtColor.getGreen();
			int b = awtColor.getBlue();
			HSSFPalette palette = workBook.getCustomPalette();
			poiColor = palette.findColor((byte) r, (byte) g, (byte) b);
			if (poiColor == null) {
				poiColor = palette.findSimilarColor(r, g, b);
			}
		}
	}
	return poiColor;
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
/**
 * Get an HSSFPalette index for a workbook that closely approximates the passed in colour.
 * @param workbook
 * The workbook for which the colour is being sought.
 * @param colour
 * The colour, in the form "rgb(<i>r</i>, <i>g</i>, <i>b</i>)".
 * @return
 * The index into the HSSFPallete for the workbook for a colour that approximates the passed in colour.
 */
private short getHColour( HSSFWorkbook workbook, String colour ) {
	int[] rgbInt = ColorUtil.getRGBs(colour);
	if( rgbInt == null ) {
		return 0;
	}
	
	byte[] rgbByte = new byte[] { (byte)rgbInt[0], (byte)rgbInt[1], (byte)rgbInt[2] };
	HSSFPalette palette = workbook.getCustomPalette();
	
	HSSFColor result = palette.findColor(rgbByte[0], rgbByte[1], rgbByte[2]);
	if( result == null) {
		if( paletteIndex > minPaletteIndex ) {
			--paletteIndex;
			palette.setColorAtIndex(paletteIndex, rgbByte[0], rgbByte[1], rgbByte[2]);
			return paletteIndex;
		} else {
			result = palette.findSimilarColor(rgbByte[0], rgbByte[1], rgbByte[2]);
		}
	}
	return result.getIndex();
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
@Override
public Font correctFontColorIfBackground(FontManager fm, Workbook wb, BirtStyle birtStyle, Font font) {
	HSSFPalette palette = ((HSSFWorkbook)wb).getCustomPalette();		
	
	CSSValue bgColour = birtStyle.getProperty( StyleConstants.STYLE_BACKGROUND_COLOR );
	int bgRgb[] = parseColour( bgColour == null ? null : bgColour.getCssText(), "white" );

	short fgRgb[] = HSSFColor.BLACK.triplet;
	if( ( font != null ) && ( font.getColor() != Short.MAX_VALUE ) ) {
		fgRgb = palette.getColor(font.getColor()).getTriplet();
	}
	if( ( fgRgb[0] == 255 ) && ( fgRgb[1] == 255 ) && ( fgRgb[2] == 255 ) ) {
		fgRgb[0]=fgRgb[1]=fgRgb[2]=0;
	} else if( ( fgRgb[0] == 0 ) && ( fgRgb[1] == 0 ) && ( fgRgb[2] == 0 ) ) {
		fgRgb[0]=fgRgb[1]=fgRgb[2]=255;
	}

	if( ( bgRgb[ 0 ] == fgRgb[ 0 ] ) && ( bgRgb[ 1 ] == fgRgb[ 1 ] ) && ( bgRgb[ 2 ] == fgRgb[ 2 ] ) ) {
		
		IStyle addedStyle = new AreaStyle( fm.getCssEngine() );
		addedStyle.setColor( contrastColour( bgRgb ) );
		
		return fm.getFontWithExtraStyle( font, addedStyle );
	} else {
		return font;
	}
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
public short getColorIndex(Color color) {
    Workbook workbook = getWorkbook(true);
    if (workbook instanceof HSSFWorkbook) {
        HSSFPalette palette = ((HSSFWorkbook) workbook).getCustomPalette();
        byte r = toRgb(color.getRed());
        byte g = toRgb(color.getGreen());
        byte b = toRgb(color.getBlue());

        HSSFColor index = palette.findColor(r, g, b);
        if (index == null) {
            index = palette.findSimilarColor(r, g, b);
        }
        return index.getIndex();
    }
    throw new IllegalStateException("Unexpected workbook type: " + workbook.getClass());
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
private HSSFColor buildHSSFColor(HSSFWorkbook wb,String colorStr){
	String[] color=colorStr.split(",");
	HSSFPalette palette=wb.getCustomPalette();
	byte r=BigInteger.valueOf(Integer.valueOf(color[0])).byteValue();
	byte g=BigInteger.valueOf(Integer.valueOf(color[1])).byteValue();
	byte b=BigInteger.valueOf(Integer.valueOf(color[2])).byteValue();
	HSSFColor targetColor=palette.findColor(r,g,b);
	if(targetColor==null){
		palette.setColorAtIndex(HSSFColorPredefined.LAVENDER.getIndex(), r, g,b);
		targetColor=palette.getColor(HSSFColorPredefined.LAVENDER.getIndex());
	}
	return targetColor;
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
@Override
public HSSFColor getPoiColor(Color color) {
    if (color == null) {
        return null;
    }
    HSSFPalette palette = ((HSSFWorkbook) poiWorkbook).getCustomPalette();
    return palette.findSimilarColor(color.r(), color.g(), color.b());
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
private CellStyle getValueBlockStyle() {
  CellStyle style = _workbook.createCellStyle();
  Font font = _workbook.createFont();
  HSSFPalette palette = _workbook.getCustomPalette();
  palette.setColorAtIndex(HSSFColor.BLUE_GREY.index, (byte) 238, (byte) 238, (byte) 238);
  style.setFillForegroundColor(HSSFColor.BLUE_GREY.index);
  style.setFillPattern(CellStyle.SOLID_FOREGROUND);
  style.setFont(font);
  return style;
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
/**
 * Enregistre une couleur dans le registre des couleurs
 * 
 * @param index index de la couleur
 * @param hexaColor code hexadécimal de la couleur
 */
protected final void registerColor(short index, String hexaColor) {
	if (hexaColor != null && hexaColor.matches("#[0-9a-fA-F]{6}")) {
		int red = Integer.parseInt(hexaColor.substring(1, 3), 16);
		int green = Integer.parseInt(hexaColor.substring(3, 5), 16);
		int blue = Integer.parseInt(hexaColor.substring(5, 7), 16);

		colorRegistry.put(index, new Color(red, green, blue));

		if (workbook instanceof HSSFWorkbook) {
			HSSFPalette palette = ((HSSFWorkbook) workbook).getCustomPalette();
			palette.setColorAtIndex(index, (byte) red, (byte) green, (byte) blue);
		}
	}
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
/**
 * HSSF色の文字列表現を取得する
 * 
 * @param workbook ブック
 * @param index 色インデックス
 * @return HSSF色の文字列表現
 */
private static String getHSSFColorString( HSSFWorkbook workbook, short index) {
    HSSFPalette palette = workbook.getCustomPalette();
    if ( palette.getColor( index) != null) {
        HSSFColor color = palette.getColor( index);
        return color.getHexString();
    } else {
        return "";
    }
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
private CellStyle createGlobalExportHeaderStyle(HSSFWorkbook wb) {
	final CellStyle style = createBorderedStyle(wb);
	style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);

	final HSSFPalette palette = wb.getCustomPalette();
	palette.setColorAtIndex(HSSFColor.GREY_25_PERCENT.index, ExportConstants.GRAY_5_RGB[0], ExportConstants.GRAY_5_RGB[1], ExportConstants.GRAY_5_RGB[2]);
	style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
	style.setFillPattern(CellStyle.SOLID_FOREGROUND);
	style.setFont(getItalicFont(wb, (short) 10));
	style.setWrapText(true);
	style.setIndention((short) 1);
	return style;
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
private CellStyle createHeaderStyle(HSSFWorkbook wb) {
	final CellStyle style = createBorderedStyle(wb);
	style.setAlignment(CellStyle.ALIGN_CENTER);
	style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);

	HSSFPalette palette = wb.getCustomPalette();
	palette.setColorAtIndex(HSSFColor.GREY_25_PERCENT.index, ExportConstants.GRAY_10_RGB[0], ExportConstants.GRAY_10_RGB[1], ExportConstants.GRAY_10_RGB[2]);
	style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
	style.setFillPattern(CellStyle.SOLID_FOREGROUND);
	style.setFont(getBoldFont(wb, (short) 10));
	style.setWrapText(true);
	return style;
}
 

import org.apache.poi.hssf.usermodel.HSSFPalette; //导入依赖的package包/类
private CellStyle createGroupStyle(HSSFWorkbook wb) {
	final CellStyle style = createBorderedStyle(wb);
	style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);

	HSSFPalette palette = wb.getCustomPalette();
	palette.setColorAtIndex(HSSFColor.BROWN.index, ExportConstants.LIGHTORANGE_RGB[0], ExportConstants.LIGHTORANGE_RGB[1], ExportConstants.LIGHTORANGE_RGB[2]);

	style.setFillForegroundColor(HSSFColor.BROWN.index);
	style.setFillPattern(CellStyle.SOLID_FOREGROUND);
	style.setFont(getItalicFont(wb, (short) 10));
	style.setWrapText(true);
	return style;
}