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

Package org.apache.poi.xssf.usermodel.extensions

Examples of org.apache.poi.xssf.usermodel.extensions.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.

      for (CTFill fill : doc.getStyleSheet().getFills().getFillList()) {
        fills.add(new XSSFCellFill(fill));
      }
      if(doc.getStyleSheet().getBorders() != null)
      for (CTBorder border : doc.getStyleSheet().getBorders().getBorderList()) {
        borders.add(new XSSFCellBorder(border));
      }
            CTCellXfs cellXfs = doc.getStyleSheet().getCellXfs();
            if(cellXfs != null) xfs.addAll(cellXfs.getXfList());


            CTCellStyleXfs cellStyleXfs = doc.getStyleSheet().getCellStyleXfs();

View Full Code Here

    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

     */
    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

     */
    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

     */
    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

     */
    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

        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

        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

        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

        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 6 7 8 9

TOP

Related Classes of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

org.apache.poi.xssf.model.StylesTable

org.apache.poi.xssf.usermodel.TestXSSFCellStyle

org.apache.poi.xssf.usermodel.XSSFCellStyle

org.apache.poi.xssf.usermodel.XSSFColor

org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorderPr

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.