我有这种格式在Java日期：“2014年1月31日14点24分28秒”。 我愿把它变成Excel中使用Apache POI库单元格格式：“日期”。 我怎样才能实现这一目标？
Answer 1:
请点击这里 ：在你想要的格式更改日期和使用。
Workbook wb = new HSSFWorkbook();
//Workbook wb = new XSSFWorkbook();
CreationHelper createHelper = wb.getCreationHelper();
Sheet sheet = wb.createSheet("new sheet");
// Create a row and put some cells in it. Rows are 0 based.
Row row = sheet.createRow(0);
// Create a cell and put a date value in it. The first cell is not styled
// as a date.
Cell cell = row.createCell(0);
cell.setCellValue(new Date());
// we style the second cell as a date (and time). It is important to
// create a new cell style from the workbook otherwise you can end up
// modifying the built in style and effecting not only this cell but other cells.
CellStyle cellStyle = wb.createCellStyle();
cellStyle.setDataFormat(
createHelper.createDataFormat().getFormat("yyyy/mm/dd hh:mm:ss"));
cell = row.createCell(1);
cell.setCellValue(new Date());
cell.setCellStyle(cellStyle);
//you can also set date as java.util.Calendar
cell = row.createCell(2);
cell.setCellValue(Calendar.getInstance());
cell.setCellStyle(cellStyle);
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
Answer 2:
尝试这个
DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd"); HSSFCell myCell; myCell.setCellValue(dateFormat.format("2014.01.31 14:24:28"));
文章来源: org.apache.poi create excel workbook with date cells
