org.apache.poi.hssf.usermodel.HSSFWorkbook.getCustomPalette()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(5.4k)|赞(0)|评价(0)|浏览(279)

本文整理了Java中org.apache.poi.hssf.usermodel.HSSFWorkbook.getCustomPalette()方法的一些代码示例,展示了HSSFWorkbook.getCustomPalette()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。HSSFWorkbook.getCustomPalette()方法的具体详情如下:
包路径:org.apache.poi.hssf.usermodel.HSSFWorkbook
类名称:HSSFWorkbook
方法名:getCustomPalette

HSSFWorkbook.getCustomPalette介绍

暂无

代码示例

代码示例来源:origin: stackoverflow.com

  1. HSSFWorkbook hwb = new HSSFWorkbook();
  2. HSSFPalette palette = hwb.getCustomPalette();
  3. // get the color which most closely matches the color you want to use
  4. HSSFColor myColor = palette.findSimilarColor(255, 0, 0);
  5. // get the palette index of that color
  6. short palIndex = myColor.getIndex();
  7. // code to get the style for the cell goes here
  8. style.setFillForegroundColor(palIndex);

代码示例来源:origin: org.apache.poi/poi

  1. @Override
  2. public HSSFColor getTopBorderColorColor() {
  3. return workbook.getCustomPalette().getColor(
  4. borderFormatting.getTopBorderColor()
  5. );
  6. }

代码示例来源:origin: org.apache.poi/poi

  1. @Override
  2. public HSSFColor getLeftBorderColorColor() {
  3. return workbook.getCustomPalette().getColor(
  4. borderFormatting.getLeftBorderColor()
  5. );
  6. }

代码示例来源:origin: org.apache.poi/poi

  1. /**
  2. * get the color value for the font
  3. */
  4. public HSSFColor getHSSFColor(HSSFWorkbook wb)
  5. {
  6. HSSFPalette pallette = wb.getCustomPalette();
  7. return pallette.getColor( getColor() );
  8. }

代码示例来源:origin: org.apache.poi/poi

  1. public HSSFColor getFontColor() {
  2. return workbook.getCustomPalette().getColor(
  3. getFontColorIndex()
  4. );
  5. }

代码示例来源:origin: org.apache.poi/poi

  1. @Override
  2. public HSSFColor getBottomBorderColorColor() {
  3. return workbook.getCustomPalette().getColor(
  4. borderFormatting.getBottomBorderColor()
  5. );
  6. }

代码示例来源:origin: org.apache.poi/poi

  1. @Override
  2. public HSSFColor getDiagonalBorderColorColor() {
  3. return workbook.getCustomPalette().getColor(
  4. borderFormatting.getDiagonalBorderColor()
  5. );
  6. }

代码示例来源:origin: org.apache.poi/poi

  1. @Override
  2. public HSSFColor getRightBorderColorColor() {
  3. return workbook.getCustomPalette().getColor(
  4. borderFormatting.getRightBorderColor()
  5. );
  6. }

代码示例来源:origin: org.apache.poi/poi

  1. public HSSFColor getFillBackgroundColorColor() {
  2. return workbook.getCustomPalette().getColor(getFillBackgroundColor());
  3. }

代码示例来源:origin: org.apache.poi/poi

  1. public HSSFColor getFillForegroundColorColor() {
  2. return workbook.getCustomPalette().getColor(getFillForegroundColor());
  3. }

代码示例来源:origin: stackoverflow.com

  1. public HSSFColor setColor(HSSFWorkbook workbook, byte r,byte g, byte b){
  2. HSSFPalette palette = workbook.getCustomPalette();
  3. HSSFColor hssfColor = null;
  4. try {
  5. hssfColor= palette.findColor(r, g, b);
  6. if (hssfColor == null ){
  7. palette.setColorAtIndex(HSSFColor.LAVENDER.index, r, g,b);
  8. hssfColor = palette.getColor(HSSFColor.LAVENDER.index);
  9. }
  10. } catch (Exception e) {
  11. logger.error(e);
  12. }
  13. return hssfColor;
  14. }

代码示例来源:origin: org.apache.poi/poi

  1. private HSSFFont matchFont( Font matchFont )
  2. {
  3. HSSFColor hssfColor = workbook.getCustomPalette()
  4. .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  5. if (hssfColor == null)
  6. hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue());
  7. boolean bold = (matchFont.getStyle() & Font.BOLD) != 0;
  8. boolean italic = (matchFont.getStyle() & Font.ITALIC) != 0;
  9. HSSFFont hssfFont = workbook.findFont(bold,
  10. hssfColor.getIndex(),
  11. (short)(matchFont.getSize() * 20),
  12. matchFont.getName(),
  13. italic,
  14. false,
  15. (short)0,
  16. (byte)0);
  17. if (hssfFont == null)
  18. {
  19. hssfFont = workbook.createFont();
  20. hssfFont.setBold(bold);
  21. hssfFont.setColor(hssfColor.getIndex());
  22. hssfFont.setFontHeight((short)(matchFont.getSize() * 20));
  23. hssfFont.setFontName(matchFont.getName());
  24. hssfFont.setItalic(italic);
  25. hssfFont.setStrikeout(false);
  26. hssfFont.setTypeOffset((short) 0);
  27. hssfFont.setUnderline((byte) 0);
  28. }
  29. return hssfFont;
  30. }

代码示例来源:origin: primefaces/primefaces

  1. String cellFontColor = options.getCellFontColor();
  2. if (cellFontColor != null) {
  3. HSSFPalette palette = ((HSSFWorkbook) wb).getCustomPalette();
  4. Color color = Color.decode(cellFontColor);
  5. HSSFColor cellColor = palette.findSimilarColor(color.getRed(), color.getGreen(), color.getBlue());

代码示例来源:origin: primefaces/primefaces

  1. HSSFPalette palette = ((HSSFWorkbook) wb).getCustomPalette();
  2. Color color = null;

代码示例来源:origin: youseries/ureport

  1. private HSSFColor buildHSSFColor(HSSFWorkbook wb,String colorStr){
  2. String[] color=colorStr.split(",");
  3. HSSFPalette palette=wb.getCustomPalette();
  4. byte r=BigInteger.valueOf(Integer.valueOf(color[0])).byteValue();
  5. byte g=BigInteger.valueOf(Integer.valueOf(color[1])).byteValue();
  6. byte b=BigInteger.valueOf(Integer.valueOf(color[2])).byteValue();
  7. HSSFColor targetColor=palette.findColor(r,g,b);
  8. if(targetColor==null){
  9. palette.setColorAtIndex(HSSFColorPredefined.LAVENDER.getIndex(), r, g,b);
  10. targetColor=palette.getColor(HSSFColorPredefined.LAVENDER.getIndex());
  11. }
  12. return targetColor;
  13. }

代码示例来源:origin: stackoverflow.com

  1. HSSFPalette palette = wb.getCustomPalette();

代码示例来源:origin: org.apache.poi/poi-examples

  1. public HSSFHtmlHelper(HSSFWorkbook wb) {
  2. this.wb = wb;
  3. // If there is no custom palette, then this creates a new one that is
  4. // a copy of the default
  5. colors = wb.getCustomPalette();
  6. }

代码示例来源:origin: com.haulmont.thirdparty/poi

  1. /**
  2. * get the color value for the font
  3. */
  4. public HSSFColor getHSSFColor(HSSFWorkbook wb)
  5. {
  6. HSSFPalette pallette = wb.getCustomPalette();
  7. return pallette.getColor( getColor() );
  8. }

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

  1. @Override
  2. public HSSFColor getLeftBorderColorColor() {
  3. return workbook.getCustomPalette().getColor(
  4. borderFormatting.getLeftBorderColor()
  5. );
  6. }

代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

  1. @Override
  2. public HSSFColor getRightBorderColorColor() {
  3. return workbook.getCustomPalette().getColor(
  4. borderFormatting.getRightBorderColor()
  5. );
  6. }

相关文章

HSSFWorkbook类方法