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

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

941
942
943
944
945
946
947
948
949
950
        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, _theme));

        _cellXf.setBorderId(idx);
        _cellXf.setApplyBorder(true);
    }
View Full Code Here
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
     */
    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
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
        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, _theme));

        _cellXf.setBorderId(idx);
        _cellXf.setApplyBorder(true);
    }
View Full Code Here
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
        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, _theme));

        _cellXf.setBorderId(idx);
        _cellXf.setApplyBorder(true);
    }
View Full Code Here
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
        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, _theme));

        _cellXf.setBorderId(idx);
        _cellXf.setApplyBorder(true);
    }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
    stylesTable = new StylesTable();

    ctStylesheet = stylesTable.getCTStylesheet();

    ctBorderA = CTBorder.Factory.newInstance();
    XSSFCellBorder borderA = new XSSFCellBorder(ctBorderA);
    long borderId = stylesTable.putBorder(borderA);
    assertEquals(1, borderId);

    XSSFCellBorder borderB = new XSSFCellBorder();
    assertEquals(1, stylesTable.putBorder(borderB));

    ctFill = CTFill.Factory.newInstance();
    XSSFCellFill fill = new XSSFCellFill(ctFill);
    long fillId = stylesTable.putFill(fill);
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
            }

            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
459
460
461
462
463
464
465
466
467
468
469
    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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
    stylesTable = new StylesTable();

    ctStylesheet = stylesTable.getCTStylesheet();

    ctBorderA = CTBorder.Factory.newInstance();
    XSSFCellBorder borderA = new XSSFCellBorder(ctBorderA);
    long borderId = stylesTable.putBorder(borderA);
    assertEquals(1, borderId);

    XSSFCellBorder borderB = new XSSFCellBorder();
    assertEquals(1, stylesTable.putBorder(borderB));

    ctFill = CTFill.Factory.newInstance();
    XSSFCellFill fill = new XSSFCellFill(ctFill);
    long fillId = stylesTable.putFill(fill);
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
      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.