public static boolean CreateExcelFile01(String filePath, String fileName){
try {
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet();
workbook.setSheetName(0,"固定格式的单元格");
HSSFRow row = sheet.createRow(0);
HSSFCell Lable_cell = row.createCell(0);
Lable_cell.setCellValue("日期");
HSSFRow row1 = sheet.createRow(1);
HSSFCell date_cell = row1.createCell(0);
date_cell.setCellValue(new Date());
//创建单元格样式对象
HSSFCellStyle cellStyle = workbook.createCellStyle();
//创建格式化对象
HSSFDataFormat dataFormat = workbook.createDataFormat();
cellStyle.setDataFormat(dataFormat.getFormat("yyyy年m月d日"));
//格式化单元格
date_cell.setCellStyle(cellStyle);
File file = new File(filePath,fileName);
//创建文件输出流对象
FileOutputStream outputStream = new FileOutputStream(file);
workbook.write(outputStream);
outputStream.close();
return true;
}catch (Exception e){
return false;
}
}