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

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

764
765
766
767
768
769
770
771
772
773
        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
804
805
806
807
808
809
810
811
812
813
        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
844
845
846
847
848
849
850
851
852
853
        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
884
885
886
887
888
889
890
891
892
893
        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
923
924
925
926
927
928
929
930
931
932
        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
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
     */
    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
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
        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
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
        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
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
        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
118
119
120
121
122
123
124
125
126
127
128
      for (CTFill fill : doc.getStyleSheet().getFills().getFillArray()) {
        fills.add(new XSSFCellFill(fill));
      }
      if(doc.getStyleSheet().getBorders() != null)
      for (CTBorder border : doc.getStyleSheet().getBorders().getBorderArray()) {
        borders.add(new XSSFCellBorder(border));
      }
      if(doc.getStyleSheet().getCellXfs() != null)
      for (CTXf xf : doc.getStyleSheet().getCellXfs().getXfArray()) {
        xfs.add(xf);
      }
View Full Code Here
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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.