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

            }


            CTBorders ctborders = styleSheet.getBorders();
            if(ctborders != null) {
                for (CTBorder border : ctborders.getBorderArray()) {
                    borders.add(new XSSFCellBorder(border));
                }
            }


            CTCellXfs cellXfs = styleSheet.getCellXfs();
            if(cellXfs != null) xfs.addAll(Arrays.asList(cellXfs.getXfArray()));

View Full Code Here

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, _theme));


        _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, _theme));


        _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, _theme));


        _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, _theme));


        _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.