Examples of XSSFCellBorder

org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder
This element contains border formatting information, specifying border definition formats (left, right, top, bottom, diagonal) for cells in the workbook. Color is optional.

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

    CTFill[] ctFill = createDefaultFills();
    fills.add(new XSSFCellFill(ctFill[0]));
    fills.add(new XSSFCellFill(ctFill[1]));


    CTBorder ctBorder = createDefaultBorder();
    borders.add(new XSSFCellBorder(ctBorder));


    CTXf styleXf = createDefaultXf();
    styleXfs.add(styleXf);
    CTXf xf = createDefaultXf();
    xf.setXfId(0);

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

     */
    public XSSFColor getBottomBorderXSSFColor() {
        if(!cellXf.getApplyBorder()) return null;


        int idx = (int)cellXf.getBorderId();
        XSSFCellBorder border = stylesSource.getBorderAt(idx);


        return border.getBorderColor(BorderSide.BOTTOM);
    }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

     */
    public XSSFColor getLeftBorderXSSFColor() {
        if(!cellXf.getApplyBorder()) return null;


        int idx = (int)cellXf.getBorderId();
        XSSFCellBorder border = stylesSource.getBorderAt(idx);


        return border.getBorderColor(BorderSide.LEFT);
    }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

     */
    public XSSFColor getRightBorderXSSFColor() {
        if(!cellXf.getApplyBorder()) return null;


        int idx = (int)cellXf.getBorderId();
        XSSFCellBorder border = stylesSource.getBorderAt(idx);


        return border.getBorderColor(BorderSide.RIGHT);
    }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

     */
    public XSSFColor getTopBorderXSSFColor() {
        if(!cellXf.getApplyBorder()) return null;


        int idx = (int)cellXf.getBorderId();
        XSSFCellBorder border = stylesSource.getBorderAt(idx);


        return border.getBorderColor(BorderSide.TOP);
    }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

        CTBorder ct = getCTBorder();
        CTBorderPr pr = ct.isSetBottom() ? ct.getBottom() : ct.addNewBottom();
        if(border == BORDER_NONE) ct.unsetBottom();
        else pr.setStyle(STBorderStyle.Enum.forInt(border + 1));


        int idx = stylesSource.putBorder(new XSSFCellBorder(ct));


        cellXf.setBorderId(idx);
        cellXf.setApplyBorder(true);
    }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

        CTBorder ct = getCTBorder();
        CTBorderPr pr = ct.isSetLeft() ? ct.getLeft() : ct.addNewLeft();
        if(border == BORDER_NONE) ct.unsetLeft();
        else pr.setStyle(STBorderStyle.Enum.forInt(border + 1));


        int idx = stylesSource.putBorder(new XSSFCellBorder(ct));


        cellXf.setBorderId(idx);
        cellXf.setApplyBorder(true);
    }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

        CTBorder ct = getCTBorder();
        CTBorderPr pr = ct.isSetRight() ? ct.getRight() : ct.addNewRight();
        if(border == BORDER_NONE) ct.unsetRight();
        else pr.setStyle(STBorderStyle.Enum.forInt(border + 1));


        int idx = stylesSource.putBorder(new XSSFCellBorder(ct));


        cellXf.setBorderId(idx);
        cellXf.setApplyBorder(true);
    }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

        CTBorder ct = getCTBorder();
        CTBorderPr pr = ct.isSetTop() ? ct.getTop() : ct.addNewTop();
        if(border == BORDER_NONE) ct.unsetTop();
        else pr.setStyle(STBorderStyle.Enum.forInt(border + 1));


        int idx = stylesSource.putBorder(new XSSFCellBorder(ct));


        cellXf.setBorderId(idx);
        cellXf.setApplyBorder(true);
    }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder


        CTBorderPr pr = ct.isSetBottom() ? ct.getBottom() : ct.addNewBottom();
        if(color != null)  pr.setColor(color.getCTColor());
        else pr.unsetColor();


        int idx = stylesSource.putBorder(new XSSFCellBorder(ct));


        cellXf.setBorderId(idx);
        cellXf.setApplyBorder(true);
    }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.