public ContentProvider newInstance() { return new XlsContentProvider(this.exportContext, this.workbook); }
@Override public XlsContentProvider setColWidths(final int... charLengths) { for (int colIdx = 0; colIdx < charLengths.length; colIdx++) { putColWidth(colIdx, charLengths[colIdx]); } return this; }
@Override public XlsContentProvider putFormat(final ExportColumn col, final String dataFormat) { registerColumn(col); putFormat((Object) col, dataFormat); return this; }
final Object customizedValue = getCustomizedValue(value); if (customizedValue != null) { if (customizedValue instanceof Calendar) { poiCell.setCellValue(ConvertUtils.convert(value)); CellFormat cellFormat = getCellFormat(cell, value, property, formatMap); if (cellFormat == null) { cellFormat = getCellFormat(cell, value, property, defaultFormatMap);
@Override public XlsContentProvider putFormat(final String dataFormat, final Enum<?>... cols) { for (final Enum<?> col : cols) { putFormat(col, dataFormat); } return this; }
@Override public XlsContentProvider setValue(final ExportCell cell, final Object value) { setValue(cell, value, null); return this; }
final CellFormat customizedCellFormat = getCustomizedCellFormat(format, value); if (customizedCellFormat != null) { format = customizedCellFormat;
public XlsContentProvider(final ExportContext exportContext, final ExportWorkbook workbook) { this.exportContext = exportContext; this.workbook = workbook; createFonts(); defaultFormatMap.put(Integer.class, new CellFormat("#,##0", CellStyle.ALIGN_RIGHT)); defaultFormatMap.put(Number.class, new CellFormat("#,###.######", CellStyle.ALIGN_RIGHT)); defaultFormatMap .put(Date.class, new CellFormat(ExcelDateFormats.getExcelFormatString(exportContext, DateFormatType.DATE_TIME_MINUTES))); defaultFormatMap.put(java.sql.Date.class, new CellFormat(ExcelDateFormats.getExcelFormatString(exportContext, DateFormatType.DATE))); defaultFormatMap.put(java.sql.Timestamp.class, new CellFormat(ExcelDateFormats.getExcelFormatString(exportContext, DateFormatType.DATE_TIME_MILLIS))); }
public ExportWorkbook(final InputStream is) throws IOException { try { poiWorkbook = new HSSFWorkbook(is, true); final int no = poiWorkbook.getNumberOfSheets(); sheets = new ArrayList<ExportSheet>(no); for (int i = 0; i < no; i++) { final Sheet sh = poiWorkbook.getSheetAt(i); final XlsContentProvider cp = (XlsContentProvider) ExportConfig.getInstance().createNewContentProvider(this); cp.setAutoFormatCells(false); final ExportSheet sheet = new ExportSheet(cp, poiWorkbook.getSheetName(i), sh); sheet.setImported(true); sheets.add(sheet); } } finally { if (is != null) { is.close(); } } }
@Override public XlsContentProvider putFormat(final Enum<?> col, final CellFormat cellFormat) { putFormat(col.name(), cellFormat); return this; }
@Override public XlsContentProvider putFormat(final Enum<?> col, final String dataFormat) { putFormat(col.name(), dataFormat); return this; }
/** * Override this method for own {@link XlsContentProvider}. * * @param workbook * @return */ protected ContentProvider createNewContentProvider(ExportWorkbook workbook) { return new XlsContentProvider(getDefaultExportContext(), workbook); }