public Row createRow(org.xlsx4j.sml.ObjectFactory factory, String stringContent, int colNum, long rowNum) { Row row = factory.createRow(); row.setR(rowNum); Cell cell = createCell(factory, stringContent, colNum, rowNum); cell.setS(1L); row.getC().add(cell); return row; }
protected void saveXlsxAsCsv(Document document, OutputStream outputStream) throws IOException, Docx4JException { CSVWriter writer = new CSVWriter(new OutputStreamWriter(outputStream), ';', CSVWriter.DEFAULT_QUOTE_CHARACTER); for (Document.SheetWrapper sheetWrapper : document.getWorksheets()) { Worksheet worksheet = sheetWrapper.getWorksheet().getContents(); for (Row row : worksheet.getSheetData().getRow()) { String rows[] = new String[row.getC().size()]; List<Cell> cells = row.getC(); boolean emptyRow = true; for (int i = 0; i < cells.size(); i++) { checkThreadInterrupted(); Cell cell = cells.get(i); String value = cell.getV(); rows[i] = value; if (value != null && !value.isEmpty()) emptyRow = false; } if (!emptyRow) writer.writeNext(rows); } } writer.close(); }
protected void saveXlsxAsCsv(Document document, OutputStream outputStream) throws IOException, Docx4JException { CSVWriter writer = new CSVWriter(new OutputStreamWriter(outputStream), ';', CSVWriter.DEFAULT_QUOTE_CHARACTER); for (Document.SheetWrapper sheetWrapper : document.getWorksheets()) { Worksheet worksheet = sheetWrapper.getWorksheet().getContents(); for (Row row : worksheet.getSheetData().getRow()) { String rows[] = new String[row.getC().size()]; List<Cell> cells = row.getC(); boolean emptyRow = true; for (int i = 0; i < cells.size(); i++) { checkThreadInterrupted(); Cell cell = cells.get(i); String value = cell.getV(); rows[i] = value; if (value != null && !value.isEmpty()) emptyRow = false; } if (!emptyRow) writer.writeNext(rows); } } writer.close(); }
public Map<CellReference, Cell> getCellsByRange(Range range) { Worksheet sheet = getSheetByName(range.getSheet()); SheetData data = sheet.getSheetData(); Map<CellReference, Cell> result = new LinkedHashMap<CellReference, Cell>(); for (int i = 1; i <= data.getRow().size(); i++) { Row row = data.getRow().get(i - 1); if (range.getFirstRow() <= row.getR() && row.getR() <= range.getLastRow()) { List<Cell> c = row.getC(); for (Cell cell : c) { CellReference cellReference = new CellReference(range.getSheet(), cell.getR()); if (range.getFirstColumn() <= cellReference.getColumn() && cellReference.getColumn() <= range.getLastColumn()) { result.put(cellReference, cell); } } } } return result; }
public Map<CellReference, Cell> getCellsByRange(Range range) { Worksheet sheet = getSheetByName(range.getSheet()); SheetData data = sheet.getSheetData(); Map<CellReference, Cell> result = new LinkedHashMap<>(); for (int i = 1; i <= data.getRow().size(); i++) { Row row = data.getRow().get(i - 1); if (range.getFirstRow() <= row.getR() && row.getR() <= range.getLastRow()) { List<Cell> c = row.getC(); for (Cell cell : c) { CellReference cellReference = new CellReference(range.getSheet(), cell.getR()); if (range.getFirstColumn() <= cellReference.getColumn() && cellReference.getColumn() <= range.getLastColumn()) { result.put(cellReference, cell); } } } } return result; }
newRow.getC().add(newCell); newCell.setParent(newRow);
newRow.getC().add(newCell); newCell.setParent(newRow);
Row row = factory.createRow(); row.setR(rowNum); row.getC().add(createCell(factory, regionProperty.getHierarchicalLocalizedNameExceptRoot() + ":", 1, rowNum)); row.getC().add(createCell(factory, reportTemplatePlaceholder.getPlaceholderValue(regionProperty.getHierarchicalNameExceptRoot(), reportRegion), 2, rowNum)); sheetData.getRow().add(row); rowNum++;