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

     */
    private CTBorder getCTBorder(){
        CTBorder ct;
        if(cellXf.getApplyBorder()) {
            int idx = (int)cellXf.getBorderId();
            XSSFCellBorder cf = stylesSource.getBorderAt(idx);


            ct = (CTBorder)cf.getCTBorder().copy();
        } else {
            ct = CTBorder.Factory.newInstance();
        }
        return ct;
    }

View Full Code Here

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


        CTBorderPr pr = ct.isSetLeft() ? ct.getLeft() : ct.addNewLeft();
        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

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


        CTBorderPr pr = ct.isSetRight() ? ct.getRight() : ct.addNewRight();
        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

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


        CTBorderPr pr = ct.isSetTop() ? ct.getTop() : ct.addNewTop();
        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

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

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.