public void clearWorkbook() { for (SheetWrapper sheet : worksheets) { getWorksheetContents(sheet).getSheetData().getRow().clear(); CTMergeCells mergeCells = getWorksheetContents(sheet).getMergeCells(); if (mergeCells != null && mergeCells.getMergeCell() != null) { mergeCells.getMergeCell().clear(); } try { CTPageBreak rowBreaks = sheet.worksheet.getContents().getRowBreaks(); if (rowBreaks != null && rowBreaks.getBrk() != null) { rowBreaks.getBrk().clear(); } } catch (Docx4JException e) { throw new ReportFormattingException("An error occurred while clearing docx4j workbook", e); } } workbook.getDefinedNames().getDefinedName().clear(); }
protected void copyRowSettings(Row templateRow, Row newRow, Worksheet templateWorksheet, Worksheet resultWorksheet) { newRow.setHt(templateRow.getHt()); newRow.setCustomHeight(true); CTPageBreak rowBreaks = templateWorksheet.getRowBreaks(); if (rowBreaks != null && rowBreaks.getBrk() != null) { CTPageBreak resultWorksheetRowBreaks = resultWorksheet.getRowBreaks(); for (CTBreak templateBreak : rowBreaks.getBrk()) { if (templateRow.getR().equals(templateBreak.getId())) { CTBreak newBreak = XmlUtils.deepCopy(templateBreak, Context.jcSML); newBreak.setId(newRow.getR()); resultWorksheetRowBreaks.getBrk().add(newBreak); } } long rowBreaksCount = resultWorksheetRowBreaks.getBrk().size(); resultWorksheetRowBreaks.setCount(rowBreaksCount); resultWorksheetRowBreaks.setManualBreakCount(rowBreaksCount); } newRow.setOutlineLevel(templateRow.getOutlineLevel()); }
public void clearWorkbook() { for (SheetWrapper sheet : worksheets) { sheet.worksheet.getJaxbElement().getSheetData().getRow().clear(); CTMergeCells mergeCells = sheet.worksheet.getJaxbElement().getMergeCells(); if (mergeCells != null && mergeCells.getMergeCell() != null) { mergeCells.getMergeCell().clear(); } try { CTPageBreak rowBreaks = sheet.worksheet.getContents().getRowBreaks(); if (rowBreaks != null && rowBreaks.getBrk() != null) { rowBreaks.getBrk().clear(); } } catch (Docx4JException e) { throw new ReportFormattingException("An error occurred while clearing docx4j workbook", e); } } workbook.getDefinedNames().getDefinedName().clear(); }
protected void copyRowSettings(Row templateRow, Row newRow, Worksheet templateWorksheet, Worksheet resultWorksheet) { newRow.setHt(templateRow.getHt()); newRow.setCustomHeight(true); CTPageBreak rowBreaks = templateWorksheet.getRowBreaks(); if (rowBreaks != null && rowBreaks.getBrk() != null) { CTPageBreak resultWorksheetRowBreaks = resultWorksheet.getRowBreaks(); for (CTBreak templateBreak : rowBreaks.getBrk()) { if (templateRow.getR().equals(templateBreak.getId())) { CTBreak newBreak = XmlUtils.deepCopy(templateBreak, Context.jcSML); newBreak.setId(newRow.getR()); resultWorksheetRowBreaks.getBrk().add(newBreak); } } long rowBreaksCount = resultWorksheetRowBreaks.getBrk().size(); resultWorksheetRowBreaks.setCount(rowBreaksCount); resultWorksheetRowBreaks.setManualBreakCount(rowBreaksCount); } newRow.setOutlineLevel(templateRow.getOutlineLevel()); }