/** * Cells in the Sheet Part reference the xf (data format) records by zero-based index. * * @param idx * @return */ public CTXf getXfByIndex(long idx) { if (this.getJaxbElement().getCellXfs()!=null) { return this.getJaxbElement().getCellXfs().getXf().get( (int)idx); } return null; }
/** * Cells in the Sheet Part reference the xf (data format) records by zero-based index. * * @param idx * @return */ public CTXf getXfByIndex(long idx) { if (this.getJaxbElement().getCellXfs()!=null) { return this.getJaxbElement().getCellXfs().getXf().get( (int)idx); } return null; }
public void saveStyle() { if (!newCellXfs.isEmpty()) { CTCellXfs ctCellXfs = ctStylesheet.getCellXfs(); if (ctCellXfs == null) { ctCellXfs = new CTCellXfs(); ctStylesheet.setCellXfs(ctCellXfs); } ctCellXfs.setCount((long) cellXfsIndex.size()); List<CTXf> xfs = ctCellXfs.getXf(); for (CellXfs cellXfs : newCellXfs) { CTXf ctXf = new CTXf(); ctXf.setNumFmtId(cellXfs.getNumFmtId()); ctXf.setFontId(cellXfs.getFontId()); ctXf.setFillId(cellXfs.getFillId()); ctXf.setBorderId(cellXfs.getBorderId()); ctXf.setXfId(cellXfs.getXfId()); ctXf.setParent(ctCellXfs); xfs.add(ctXf); } } }
public void saveStyle() { if (!newCellXfs.isEmpty()) { CTCellXfs ctCellXfs = ctStylesheet.getCellXfs(); if (ctCellXfs == null) { ctCellXfs = new CTCellXfs(); ctStylesheet.setCellXfs(ctCellXfs); } ctCellXfs.setCount((long) cellXfsIndex.size()); List<CTXf> xfs = ctCellXfs.getXf(); for (CellXfs cellXfs : newCellXfs) { CTXf ctXf = new CTXf(); ctXf.setNumFmtId(cellXfs.getNumFmtId()); ctXf.setFontId(cellXfs.getFontId()); ctXf.setFillId(cellXfs.getFillId()); ctXf.setBorderId(cellXfs.getBorderId()); ctXf.setXfId(cellXfs.getXfId()); ctXf.setParent(ctCellXfs); xfs.add(ctXf); } } }
for (CTXf xf : ctCellXfs.getXf()) { CellXfs cellXfs = new CellXfs(xf.getXfId(), xf.getNumFmtId(),
for (CTXf xf : ctCellXfs.getXf()) { CellXfs cellXfs = new CellXfs(xf.getXfId(), xf.getNumFmtId(),
cellAlignment.setVertical(STVerticalAlignment.JUSTIFY); stylesheet.getCellXfs().getXf().add(generateCTXf(0l, 0l, null, 0l, 0l, cellAlignment, null)); stylesheet.getCellXfs().getXf().add(generateCTXf(1l, 0l, null, 0l, 0l, cellAlignment, true)); stylesheet.setCellStyles(new CTCellStyles()); stylesheet.getCellStyles().setCount(1L);