int firstRowHeight = sheet.getRowView(firstRow).getSize(); double firstRowImageHeight = (1 - (y - firstRow)) * firstRowHeight; if (lastRow != firstRow) lastRowHeight = sheet.getRowView(lastRow).getSize(); lastRowImageHeight = (y + height - lastRow) * lastRowHeight; for (int i = 0 ; i < lastRow - firstRow - 1 ; i++) height += sheet.getRowView(firstRow + 1 + i).getSize();
int firstRowHeight = sheet.getRowView(firstRow).getSize(); double firstRowImageHeight = (1 - (y - firstRow)) * firstRowHeight; if (lastRow != firstRow) lastRowHeight = sheet.getRowView(lastRow).getSize(); lastRowImageHeight = (y + height - lastRow) * lastRowHeight; for (int i = 0 ; i < lastRow - firstRow - 1 ; i++) height += sheet.getRowView(firstRow + 1 + i).getSize();
Sheet s = ... Colour[] colorings = new Colour[]{Colour.GOLD, Colour.OCEAN_BLUE}; for(int i=0;i<s.getRows();i++){ CellView rowView = s.getRowView(i); WritableCellFormat newFormat = new WritableCellFormat(rowView.getFormat()); newFormat.setBackground(colorings[i%2]); rowView.setFormat(newFormat()); }
public static RowData createRowData(Sheet sheet, int rowNum, JexcelTransformer transformer){ return createRowData(sheet.getName(), sheet.getRow(rowNum), sheet.getRowView(rowNum), transformer); }
private static WritableSheet createSheetCopy(Workbook w, int from, int to, WritableWorkbook writeableWorkbook) throws WriteException { Sheet sheet = w.getSheet(from); WritableSheet newSheet = writeableWorkbook.getSheet(to); // Avoid warning // "Maximum number of format records exceeded. Using default format." Map<CellFormat, WritableCellFormat> definedFormats = new HashMap<CellFormat, WritableCellFormat>(); for (int colIdx = 0; colIdx < sheet.getColumns(); colIdx++) { newSheet.setColumnView(colIdx, sheet.getColumnView(colIdx)); for (int rowIdx = 0; rowIdx < sheet.getRows(); rowIdx++) { if (colIdx == 0) { newSheet.setRowView(rowIdx, sheet.getRowView(rowIdx)); } Cell readCell = sheet.getCell(colIdx, rowIdx); Label label = new Label(colIdx, rowIdx, readCell.getContents()); CellFormat readFormat = readCell.getCellFormat(); if (readFormat != null) { if (!definedFormats.containsKey(readFormat)) { definedFormats.put(readFormat, new WritableCellFormat( readFormat)); } label.setCellFormat(definedFormats.get(readFormat)); } newSheet.addCell(label); } } return newSheet; }