XSSFDataFormat df = workBook.createDataFormat(); cs.setDataFormat(df.getFormat("d-mmm-yy")); // Get / Create our cell XSSFRow row = sheet.createRow(2); XSSFCell cell = row.createCell(3); // Set it to be a date Calendar c = Calendar.getInstance(); c.set(2012,3-1,18); // Don't forget months are 0 based on Calendar cell.setCellValue( c.getTime() ); // Style it as a date cell.setCellStyle(cs);
/** * Get the contents of the format string, by looking up * the StylesSource * * @return the number format string */ @Override public String getDataFormatString() { int idx = getDataFormat(); return new XSSFDataFormat(_stylesSource).getFormat((short)idx); }
/** * Returns the workbook's data format table (a factory for creating data format strings). * * @return the XSSFDataFormat object * @see org.apache.poi.ss.usermodel.DataFormat */ @Override public XSSFDataFormat createDataFormat() { if (formatter == null) { formatter = new XSSFDataFormat(stylesSource); } return formatter; }
/** * Returns the instance of XSSFDataFormat for this workbook. * * @return the XSSFDataFormat object * @see org.apache.poi.ss.usermodel.DataFormat */ public XSSFDataFormat createDataFormat() { if (formatter == null) formatter = new XSSFDataFormat(stylesSource); return formatter; }
@Override public void reset(XSSFWorkbook workbook) { style = workbook.createCellStyle(); style.setDataFormat(workbook.getCreationHelper() .createDataFormat().getFormat(formatString)); }
(new XSSFDataFormat(_stylesSource)).getFormat(fmt) );
/** * Returns the workbook's data format table (a factory for creating data format strings). * * @return the XSSFDataFormat object * @see org.apache.poi.ss.usermodel.DataFormat */ @Override public XSSFDataFormat createDataFormat() { if (formatter == null) { formatter = new XSSFDataFormat(stylesSource); } return formatter; }
XSSFDataFormat df = wb.createDataFormat(); italicStyle.setDataFormat(df.getFormat("##0"));
/** * Get the contents of the format string, by looking up * the StylesSource * * @return the number format string */ @Override public String getDataFormatString() { int idx = getDataFormat(); return new XSSFDataFormat(_stylesSource).getFormat((short)idx); }
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));
/** * Get the contents of the format string, by looking up * the StylesSource * * @return the number format string */ public String getDataFormatString() { int idx = getDataFormat(); return new XSSFDataFormat(_stylesSource).getFormat((short)idx); }
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"));
(new XSSFDataFormat(_stylesSource)).getFormat(fmt) );
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);
(new XSSFDataFormat(_stylesSource)).getFormat(fmt) );
private Map<String, XSSFCellStyle> getStyleMap(XSSFWorkbook wb) { Map<String, XSSFCellStyle> map = new HashMap<String, XSSFCellStyle>(); XSSFDataFormat xdf = wb.createDataFormat(); XSSFCellStyle cellStyle1 = wb.createCellStyle(); cellStyle1.setDataFormat(xdf.getFormat("###,###,###,###,###,##0.00")); map.put("Currency", cellStyle1); map.put("Default", cellStyle1); XSSFCellStyle cellStyle2 = wb.createCellStyle(); cellStyle2.setDataFormat(xdf.getFormat("###,###,###,###,###,##0.0000")); map.put("Float4", cellStyle2); XSSFCellStyle cellStyle3 = wb.createCellStyle(); cellStyle3.setDataFormat(xdf.getFormat("###,###,###,###,###,##0.000000")); map.put("Float6", cellStyle3); XSSFCellStyle cellStyle4 = wb.createCellStyle(); cellStyle4.setDataFormat(xdf.getFormat("###,###,###,###,###,##0.0000000000")); map.put("Float10", cellStyle4); XSSFCellStyle cellStyle5 = wb.createCellStyle(); cellStyle5.setDataFormat(xdf.getFormat("###,###,###,###,###,##0")); map.put("Integer", cellStyle5); XSSFCellStyle cellStyle6 = wb.createCellStyle(); cellStyle6.setDataFormat(xdf.getFormat("@")); map.put("String", cellStyle6); XSSFCellStyle cellStyle7 = wb.createCellStyle(); cellStyle7.setDataFormat(xdf.getFormat("yyyy/mm/dd")); map.put("Date", cellStyle7); XSSFCellStyle cellStyle8 = wb.createCellStyle(); cellStyle8.setDataFormat(xdf.getFormat("yyyy/mm/dd HH:MM:DD")); map.put("DateTime", cellStyle8); return map; }
private CellStyle getCellDataFormat(int scale, XSSFWorkbook workbook) { CellStyle style = workbook.createCellStyle(); if(scale > 0){ String dataFormat = "0."; for(int i = 0; i < scale; i++){ dataFormat = dataFormat+"0"; } style.setDataFormat(workbook.createDataFormat().getFormat(dataFormat)); } return style; }
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()))); } }