/** * Returns the instance of DataFormat for this workbook. * * @return the DataFormat object */ @Override public DataFormat createDataFormat() { return _wb.createDataFormat(); }
@Override public XSSFDataFormat createDataFormat() { return workbook.createDataFormat(); }
/** * Returns the instance of DataFormat for this workbook. * * @return the DataFormat object */ @Override public DataFormat createDataFormat() { return _wb.createDataFormat(); }
/** * Returns the instance of DataFormat for this workbook. * * @return the DataFormat object */ public DataFormat createDataFormat() { return _wb.createDataFormat(); }
@Override public XSSFDataFormat createDataFormat() { return workbook.createDataFormat(); }
public XSSFDataFormat createDataFormat() { return workbook.createDataFormat(); }
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; }
@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))); }
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; }
@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")); }
@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")); }
XSSFDataFormat fmt = wb.createDataFormat();
font.setFontHeightInPoints((short) 10); font.setBoldweight(Font.BOLDWEIGHT_NORMAL); DataFormat dataFormat = workbook.createDataFormat();
public void buildExcelContent(final XSSFWorkbook workbook, final XSSFSheet sheet, final Map<String, Object> filters, final Locale locale) { List<PlannedEventDTO> events = plannedEventsXLSDataProvider.getEvents(filters); fillHeaderRow(workbook, sheet, 0, locale); DataFormat dataFormat = workbook.createDataFormat(); CellStyle numberStyle = workbook.createCellStyle(); numberStyle.setDataFormat(dataFormat.getFormat("0.00###")); CellStyle dateStyle = workbook.createCellStyle(); dateStyle.setDataFormat(dataFormat.getFormat("yyyy-mm-dd")); CellStyle dateTimeStyle = workbook.createCellStyle(); dateTimeStyle.setDataFormat(dataFormat.getFormat("yyyy-mm-dd hh:mm")); CellStyle timeStyle = workbook.createCellStyle(); timeStyle.setDataFormat(dataFormat.getFormat("[HH]:MM:SS")); int rowCounter = 1; for (PlannedEventDTO plannedEventDTO : events) { rowCounter = fillEventsRows(workbook, sheet, plannedEventDTO, rowCounter++, numberStyle, dateStyle, dateTimeStyle, timeStyle, locale); } }
public void buildExcelDocument(final XSSFWorkbook xssfWorkbook, final Map<String, Object> filters, final Locale locale) { XSSFSheet sheet = xssfWorkbook.createSheet(translationService.translate("cmmsMachineParts.eventsList.report.title", locale)); fillHeaderRow(xssfWorkbook, sheet, 0, locale); DataFormat dataFormat = xssfWorkbook.createDataFormat(); CellStyle numberStyle = xssfWorkbook.createCellStyle(); numberStyle.setDataFormat(dataFormat.getFormat("0.00###")); CellStyle dateStyle = xssfWorkbook.createCellStyle(); dateStyle.setDataFormat(dataFormat.getFormat("yyyy-mm-dd")); CellStyle dateTimeStyle = xssfWorkbook.createCellStyle(); dateTimeStyle.setDataFormat(dataFormat.getFormat("yyyy-mm-dd hh:mm")); CellStyle timeStyle = xssfWorkbook.createCellStyle(); timeStyle.setDataFormat(dataFormat.getFormat("[HH]:MM:SS")); List<MaintenanceEventDTO> events = dataProvider.getEvents(filters); int rowCounter = 1; for (MaintenanceEventDTO maintenanceEventDTO : events) { rowCounter = fillEventsRows(xssfWorkbook, sheet, maintenanceEventDTO, rowCounter, numberStyle, dateStyle, dateTimeStyle, timeStyle, locale); } }
cellDateStyle.setDataFormat(workbook.createDataFormat().getFormat("yyyy-mm-dd")); cellDateStyle.setAlignment(CellStyle.ALIGN_LEFT);
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); } }