Example usage for org.apache.poi.ss.usermodel IndexedColors getIndex

Introduction

In this page you can find the example usage for org.apache.poi.ss.usermodel IndexedColors getIndex.

Prototype

public short getIndex() 

Source Link

Document

Returns index of this color

Usage

From source file:nc.noumea.mairie.appock.services.impl.ExportExcelServiceImpl.java

License:Open Source License

private CellStyle createCellWithBorderAndColor(Workbook wb, BorderStyle borderStyle,
        IndexedColors indexedColors, boolean bold) {
    CellStyle style = wb.createCellStyle();
    style.setVerticalAlignment(VerticalAlignment.CENTER);
    style.setAlignment(HorizontalAlignment.CENTER);
    if (borderStyle != null) {
        style.setBorderBottom(borderStyle);
        style.setBorderTop(borderStyle);
        style.setBorderLeft(borderStyle);
        style.setBorderRight(borderStyle);
    }/*from   ww  w.j a  v  a2  s . com*/

    if (indexedColors != null) {
        style.setFillForegroundColor(indexedColors.getIndex());
        style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
    }

    if (bold) {
        Font font = wb.createFont();
        font.setBold(true);
        style.setFont(font);
    }

    return style;
}

---

From source file:vista.ui.VistaGenerarEstadisticas.java

License:Open Source License

/**
 * Este mtodo sirve para crear un estilo de celda bsico con un estilo de
 * borde y color para borde//  w w w. ja  va2s  .co m
 *
 * @param workbook el objeto Workbook dueo de la celda
 * @param borderColor el color del borde
 * @param borderStyle el estilo del borde
 * @param halign la alineacin horizontal de la celda o un nmero negativo
 * si no se desea tener alineacin horizontal
 * @param valign la alineacin vertical de la celda o un nmero negativo si
 * no se desea tener alineacin vertical
 *
 * @return un objeto CellStyle con el estilo de la celda creado
 */
private CellStyle crearEstiloCelda(Workbook workbook, IndexedColors borderColor, short borderStyle,
        short halign, short valign) {
    CellStyle style = workbook.createCellStyle();

    //Estilo centrado y con bordes
    style.setBorderBottom(borderStyle);
    style.setBottomBorderColor(borderColor.getIndex());
    style.setBorderLeft(borderStyle);
    style.setLeftBorderColor(borderColor.getIndex());
    style.setBorderRight(borderStyle);
    style.setRightBorderColor(borderColor.getIndex());
    style.setBorderTop(borderStyle);
    style.setTopBorderColor(borderColor.getIndex());

    if (halign >= 0) {
        style.setAlignment(halign);
        style.setVerticalAlignment(valign);
    }

    return style;
}

---