将数据导出到excel与日期格式的设置

//将数据导出到excel

private HSSFWorkbook  createExcel(List<Logs> list){
            HSSFWorkbook wb = new HSSFWorkbook();
            HSSFSheet sheet = wb.createSheet("Audit Logs");
   
            //head style
            HSSFCellStyle headingCellStyle = wb.createCellStyle();
            headingCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
           
            //head font
            HSSFFont headingCellFont = wb.createFont();
            headingCellFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
            headingCellStyle.setFont(headingCellFont);
   
            // head
            HSSFRow row;
            row = sheet.createRow((short) 0);
            String names[] = { "User Type", "User Name", "IP Address", "Action", "Details", "Date" };
   
            //set list head
            for (int i = 0; i < 6; i++) {
                HSSFCell cell = row.createCell((short) (i));
                cell.setCellValue(names[i]);
                cell.setCellStyle(headingCellStyle);
            }
            //设置日期格式
            HSSFCellStyle dateCellStyle = wb.createCellStyle();
            HSSFDataFormat format = wb.createDataFormat();
            short fmt = format.getFormat("yyyy/MM/dd HH:mm:ss");
            dateCellStyle.setDataFormat(fmt);
           
            short rowCount = 1;
            for (int j = 0; j < list.size(); j++) {
                row = sheet.createRow(rowCount);
                Logs logs = list.get(j);
                int column = 0;
                HSSFCell cell = row.createCell((short) (column++));
                cell.setCellValue(logs.getUsertype());
   
                cell = row.createCell((short) (column++));
                cell.setCellValue(logs.getUsername());
   
                cell = row.createCell((short) (column++));
                cell.setCellValue(this.getIp(logs));
   
                cell = row.createCell((short) (column++));
                cell.setCellValue(logs.getAction());
   
                cell = row.createCell((short) (column++));
                cell.setCellValue(getDetails(logs));
   
                cell = row.createCell((short) (column));
                cell.setCellStyle(dateCellStyle);
                cell.setCellValue(DateUtil.format(logs.getDate(), "yyyy/MM/dd HH:mm:ss"));
                rowCount++;
            }
            FileOutputStream fos;
            StringBuffer filePath = new StringBuffer().append(Glob.tempdir());
            if(filePath.charAt(filePath.length()-1) != File.separatorChar)
                filePath.append(File.separator);
            filePath.append("export");
           
            File file = new File(filePath.toString());
            if (!file.exists()) {
                file.mkdirs();
            }
            filePath.append(File.separator);
            filePath.append(System.currentTimeMillis() + "_auditLogs.xls");
            try {
                fos = new FileOutputStream(filePath.toString());
                wb.write(fos);
                fos.flush();
                fos.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
            return wb;
        }