/** * Set the index of a data format * * @param fmt the index of a data format */ @Override public void setDataFormat(short fmt) { // XSSF supports >32,767 formats setDataFormat(fmt&0xffff); } /**
setDataFormat( (new XSSFDataFormat(_stylesSource)).getFormat(fmt) );
/** * Set the index of a data format * * @param fmt the index of a data format */ @Override public void setDataFormat(short fmt) { // XSSF supports >32,767 formats setDataFormat(fmt&0xffff); } /**
XSSFCellStyle cs = fWorkbook.createCellStyle(); cs.setDataFormat(fWorkbook.getCreationHelper().createDataFormat().getFormat("dd/MMMM/yyyy"));
XSSFCellStyle cellStyle = workBook.createCellStyle(); XSSFDataFormat format = workBook.createDataFormat(); cellStyle.setDataFormat(format.getFormat("m/d/yy h:mm")); dataCell.setCellStyle(cellStyle); // Set Cell Type not really needed, the setCellValue does it dataCell.setCellType(Cell.CELL_TYPE_NUMERIC); // Set a date value (2012-06-05 08:50) dataCell.setCellValue(new Date(1338878999635));
XSSFCellStyle style3 = wb.createCellStyle(); style3.setAlignment(XSSFCellStyle.ALIGN_RIGHT); // THIS LINE HERE! style3.setDataFormat(fmt.getFormat("$#,##0.00")); styles.put("currency", style3);`
XSSFCellStyle textFormatStyle = book.createCellStyle(); textFormatStyle.setDataFormat((short)BuiltinFormats.getBuiltinFormat("text")); XSSFCell cell = row.createCell(columnIndex++); cell.setCellStyle(textFormatStyle);
XSSFCellStyle my_style = (XSSFCellStyle) wb.createCellStyle(); XSSFFont my_font=(XSSFFont) wb.createFont(); my_font.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD); my_style.setFont(my_font); XSSFDataFormat df =(XSSFDataFormat) wb.createDataFormat(); my_style.setDataFormat(df.getFormat("#,##0"));
Cell new_cell = row.createCell(index_column_found); XSSFCellStyle cs = wBook.createCellStyle(); XSSFDataFormat df = wBook.createDataFormat(); cs.setDataFormat(df.getFormat(cell_custom_format)); new_cell.setCellStyle(cs);
public void setStyle(String name, String format) { getStyle(name).setDataFormat(workbook.getCreationHelper().createDataFormat().getFormat(format)); }
@Override public void transform(XSSFCellStyle cellStyle) { XSSFDataFormat format = sheet.getWorkbook().getCreationHelper().createDataFormat(); cellStyle.setAlignment(alignment.excelAlignment(timestamp, cellStyle)); cellStyle.setDataFormat(format.getFormat(formatProvider.getExcelDateTimeFormat(locale.getCountry()))); } }
@Override public void transform(XSSFCellStyle cellStyle) { XSSFDataFormat format = sheet.getWorkbook().getCreationHelper().createDataFormat(); cellStyle.setAlignment(alignment.excelAlignment(date, cellStyle)); cellStyle.setDataFormat(format.getFormat(formatProvider.getExcelDateFormat(locale.getCountry()))); } }
@Override public void prepareColumn(TableModel tableModel, XSSFSheet sheet, int col) { XSSFWorkbook wb = sheet.getWorkbook(); XSSFDataFormat df = wb.createDataFormat(); cellStyle = wb.createCellStyle(); XSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setBold(true); f.setColor(IndexedColors.BLACK.getIndex()); cellStyle.setFont(f); cellStyle.setDataFormat(df.getFormat("text")); cellStyle.setBorderTop(CellStyle.BORDER_THIN); cellStyle.setBorderColor(BorderSide.TOP, new XSSFColor(new Color(0, 0, 0))); cellStyle.setBorderRight(CellStyle.BORDER_THIN); cellStyle.setBorderColor(BorderSide.RIGHT, new XSSFColor(new Color(0, 0, 0))); cellStyle.setBorderBottom(CellStyle.BORDER_THIN); cellStyle.setBorderColor(BorderSide.BOTTOM, new XSSFColor(new Color(0, 0, 0))); cellStyle.setBorderLeft(CellStyle.BORDER_THIN); cellStyle.setBorderColor(BorderSide.LEFT, new XSSFColor(new Color(0, 0, 0))); }
@Override public void transform(XSSFCellStyle cellStyle) { XSSFDataFormat format = sheet.getWorkbook().getCreationHelper().createDataFormat(); cellStyle.setAlignment(alignment.excelAlignment(money, cellStyle)); cellStyle.setDataFormat(format.getFormat(getExcelCurrencyFormat(money.getCurrencyCd()))); } }
@Override public void prepareColumn(TableModel tableModel, XSSFSheet sheet, int col) { XSSFWorkbook wb = sheet.getWorkbook(); XSSFDataFormat df = wb.createDataFormat(); cellStyle = wb.createCellStyle(); XSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); cellStyle.setFont(f); cellStyle.setDataFormat(df.getFormat("m/d/yy")); }
@Override public void prepareColumn(TableModel tableModel, XSSFSheet sheet, int col) { XSSFWorkbook wb = sheet.getWorkbook(); XSSFDataFormat df = wb.createDataFormat(); cellStyle = wb.createCellStyle(); XSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); cellStyle.setFont(f); cellStyle.setDataFormat(df.getFormat("m/d/yy h:mm")); }
@Override public void prepareColumn(TableModel tableModel, XSSFSheet sheet, int col) { XSSFWorkbook wb = sheet.getWorkbook(); XSSFDataFormat df = wb.createDataFormat(); cellStyle = wb.createCellStyle(); XSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); cellStyle.setFont(f); cellStyle.setDataFormat(df.getFormat("text")); }
@Override public void prepareColumn(TableModel tableModel, XSSFSheet sheet, int col) { XSSFWorkbook wb = sheet.getWorkbook(); XSSFDataFormat df = wb.createDataFormat(); cellStyle = wb.createCellStyle(); XSSFFont f = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); cellStyle.setFont(f); cellStyle.setDataFormat(df.getFormat("text")); }
protected void createExcelHeader(XSSFWorkbook workbook, XSSFSheet tableSheet) throws Exception { XSSFFont f = workbook.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); XSSFDataFormat df = workbook.createDataFormat(); XSSFCellStyle cs = workbook.createCellStyle(); cs.setFont(f); cs.setDataFormat(df.getFormat("text")); cs.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); cs.setFillPattern(FillPatternType.SOLID_FOREGROUND); cs.setWrapText(true); XSSFCreationHelper createHelper = workbook.getCreationHelper(); XSSFRow rh = tableSheet.createRow(0); for (int i = 0; i < table.getColumnCount(); i++) { XSSFCell c1 = rh.createCell(i); c1.setCellStyle(cs); c1.setCellValue(createHelper.createRichTextString(table.getColumnName(i))); c1.setCellType(XSSFCell.CELL_TYPE_STRING); } }
private void createExcelHeader(XSSFWorkbook workbook, XSSFSheet tableSheet) throws Exception { XSSFFont f = workbook.createFont(); f.setFontHeightInPoints((short) 12); f.setColor(IndexedColors.BLACK.getIndex()); XSSFDataFormat df = workbook.createDataFormat(); XSSFCellStyle cs = workbook.createCellStyle(); cs.setFont(f); cs.setDataFormat(df.getFormat("text")); cs.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); cs.setFillPattern(FillPatternType.SOLID_FOREGROUND); cs.setWrapText(true); XSSFCreationHelper createHelper = workbook.getCreationHelper(); XSSFRow rh = tableSheet.createRow(0); for (int i = 0; i < table.getColumnCount(); i++) { XSSFCell c1 = rh.createCell(i); c1.setCellStyle(cs); c1.setCellValue(createHelper.createRichTextString(table.getColumnName(i))); c1.setCellType(XSSFCell.CELL_TYPE_STRING); } }