Example usage for org.apache.poi.xssf.usermodel XSSFColor getIndexed

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFColor getIndexed.

Prototype

public short getIndexed() 

Source Link

Usage

From source file:jdbreport.model.io.xls.poi.Excel2007Writer.java

License:Apache License

protected short colorToIndex(Workbook wb, Color color) {
    if (color == null) {
        return 0;
    }//from www .j av a2s .  c o m
    if (Color.black.equals(color)) {
        return IndexedColors.BLACK.getIndex();
    }
    if (Color.white.equals(color)) {
        return IndexedColors.WHITE.getIndex();
    }
    if (Color.blue.equals(color) || Color.blue.darker().equals(color) || Color.blue.brighter().equals(color)) {
        return IndexedColors.BLUE.getIndex();
    }
    if (Color.red.equals(color) || Color.red.darker().equals(color) || Color.red.brighter().equals(color)) {
        return IndexedColors.RED.getIndex();
    }
    if (Color.LIGHT_GRAY.equals(color)) {
        return IndexedColors.GREY_25_PERCENT.getIndex();
    }
    if (Color.GRAY.equals(color)) {
        return IndexedColors.GREY_50_PERCENT.getIndex();
    }
    if (Color.DARK_GRAY.equals(color)) {
        return IndexedColors.GREY_80_PERCENT.getIndex();
    }
    if (Color.green.equals(color) || Color.green.brighter().equals(color)
            || Color.green.darker().equals(color)) {
        return IndexedColors.GREEN.getIndex();
    }
    if (Color.magenta.equals(color) || Color.magenta.darker().equals(color)
            || Color.magenta.brighter().equals(color)) {
        return IndexedColors.MAROON.getIndex();
    }
    if (Color.orange.equals(color) || Color.orange.darker().equals(color)
            || Color.orange.brighter().equals(color)) {
        return IndexedColors.ORANGE.getIndex();
    }
    if (Color.pink.equals(color) || Color.pink.darker().equals(color) || Color.pink.brighter().equals(color)) {
        return IndexedColors.PINK.getIndex();
    }
    if (Color.yellow.equals(color) || Color.yellow.darker().equals(color)
            || Color.yellow.brighter().equals(color)) {
        return IndexedColors.YELLOW.getIndex();
    }

    XSSFColor xssfColor = new XSSFColor(color);
    return xssfColor.getIndexed();
}

---

From source file:org.bbreak.excella.core.test.util.TestUtil.java

License:Open Source License

private static String getXSSFColorString(XSSFColor color) {
    StringBuffer sb = new StringBuffer("[");
    if (color != null) {
        sb.append("Indexed=").append(color.getIndexed()).append(",");
        sb.append("Rgb=");
        if (color.getRGB() != null) {
            for (byte b : color.getRGB()) {
                sb.append(String.format("%02x", b).toUpperCase());
            }/*w w  w  . j a  v a  2  s .c o m*/
        }
        sb.append(",");
        sb.append("Tint=").append(color.getTint()).append(",");
        sb.append("Theme=").append(color.getTheme()).append(",");
        sb.append("Auto=").append(color.isAuto());
    }
    return sb.append("]").toString();
}

---

From source file:org.bbreak.excella.reports.ReportsTestUtil.java

License:Open Source License

/**
 * XSSF????//from ww w.j  ava  2  s  . c o  m
 * 
 * @param color XSSF
 * @return XSSF??
 */
private static String getXSSFColorString(XSSFColor color) {
    StringBuffer sb = new StringBuffer("[");
    if (color != null) {
        sb.append("Indexed=").append(color.getIndexed()).append(",");
        sb.append("Rgb=");
        if (color.getRGB() != null) {
            for (byte b : color.getRGB()) {
                sb.append(String.format("%02x", b).toUpperCase());
            }
        }
        sb.append(",");
        sb.append("Tint=").append(color.getTint()).append(",");
        sb.append("Theme=").append(color.getTheme()).append(",");
        sb.append("Auto=").append(color.isAuto());
    }
    return sb.append("]").toString();
}

---

From source file:org.pentaho.reporting.engine.classic.core.modules.output.table.xls.helper.XSSFExcelColorProducer.java

License:Open Source License

public short getNearestColor(final Color awtColor) {
    XSSFColor color = new XSSFColor(awtColor);
    return color.getIndexed();
}

---

From source file:ru.icc.cells.ssdc.DataLoader.java

License:Apache License

private void fillCellStyle(CStyle cellStyle, CellStyle excelCellStyle) {
    Font excelFont = workbook.getFontAt(excelCellStyle.getFontIndex());
    // TODO    CFont newFont(excelFont)
    //CFont font = new CFont();
    //cellStyle.setFont( font );
    CFont font = cellStyle.getFont();/*from  w  ww  . j  ava  2 s.com*/

    fillFont(font, excelFont);

    cellStyle.setHidden(excelCellStyle.getHidden());
    cellStyle.setLocked(excelCellStyle.getLocked());
    cellStyle.setWrapped(excelCellStyle.getWrapText());

    cellStyle.setIndention(excelCellStyle.getIndention());
    cellStyle.setRotation(excelCellStyle.getRotation());

    cellStyle.setHorzAlignment(this.getHorzAlignment(excelCellStyle.getAlignment()));
    cellStyle.setVertAlignment(this.getVertAlignment(excelCellStyle.getVerticalAlignment()));

    CBorder leftBorder = cellStyle.getLeftBorder();
    CBorder rightBorder = cellStyle.getRightBorder();
    CBorder topBorder = cellStyle.getTopBorder();
    CBorder bottomBorder = cellStyle.getBottomBorder();

    BorderType lbType = this.convertBorderType(excelCellStyle.getBorderLeft());
    BorderType rbType = this.convertBorderType(excelCellStyle.getBorderRight());
    BorderType tbType = this.convertBorderType(excelCellStyle.getBorderTop());
    BorderType bbType = this.convertBorderType(excelCellStyle.getBorderBottom());

    leftBorder.setType(lbType);
    rightBorder.setType(rbType);
    topBorder.setType(tbType);
    bottomBorder.setType(bbType);

    //   "Fill Background Color" ???,    ??,
    //   ? ??? .  ?  .
    //      "Fill Foreground Color"
    XSSFColor bgColor = (XSSFColor) excelCellStyle.getFillBackgroundColorColor();

    // ? Index   64,  ? ,         ,
    // ?  ?   null ? 
    if (null != bgColor && 64 != bgColor.getIndexed()) {
        String bgColorHexRGB = bgColor.getARGBHex().substring(2);
        cellStyle.setBgColor(new CColor(bgColorHexRGB));
    }

    //   "Fill Background Color"      ??,
    //   ? ??? .      
    XSSFColor fgColor = (XSSFColor) excelCellStyle.getFillForegroundColorColor();

    if (null != fgColor && 64 != fgColor.getIndexed()) {
        String fgColorHexRGB = fgColor.getARGBHex().substring(2);
        cellStyle.setFgColor(new CColor(fgColorHexRGB));
    }

    // TODO   
}

---