/**     * @Des 創(chuàng)建2007版Excel文件     * @Author hujin     * @date 2017/2/16 13:21     */    public static void create2007Excel(String[] title,                                        List<Object> listContent, HttpServletResponse response) throws Exception {        XSSFWorkbook workBook = new XSSFWorkbook();// 創(chuàng)建 一個(gè)excel文檔對(duì)象        XSSFSheet sheet = workBook.createSheet();// 創(chuàng)建一個(gè)工作薄對(duì)象        XSSFCellStyle style = workBook.createCellStyle();// 創(chuàng)建樣式對(duì)象        // 設(shè)置字體        XSSFFont font = workBook.createFont();// 創(chuàng)建字體對(duì)象        font.setFontHeightInPoints((short) 15);// 設(shè)置字體大小        font.setFontName("黑體");// 設(shè)置為黑體字        style.setFont(font);// 將字體加入到樣式對(duì)象        // 設(shè)置對(duì)齊方式        style.setAlignment(HSSFCellStyle.ALIGN_CENTER_SELECTION);// 水平居中        style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);// 垂直居中        //設(shè)置標(biāo)題        XSSFRow titleRow = sheet.createRow(0);// 創(chuàng)建一個(gè)行對(duì)象        for (int i = 0; i < title.length; i++) {            XSSFCell cell = titleRow.createCell(i);// 創(chuàng)建單元格            cell.setCellValue(title[i]);// 寫入當(dāng)前日期            cell.setCellStyle(style);// 應(yīng)用樣式對(duì)象        }        int i = 1;        Field[] fields = null;        for (Object obj : listContent) {            XSSFRow row = sheet.createRow(i);// 創(chuàng)建一個(gè)行對(duì)象            row.setHeightInPoints(23);// 設(shè)置行高23像素            //獲取屬性反射            fields = obj.getClass().getDeclaredFields();            int j = 0;            for (Field v : fields) {                v.setaccessible(true);                //獲取屬性                Object va = v.get(obj);                if (va == null) {                    va = "";                }                XSSFCell cell = row.createCell(j);// 創(chuàng)建單元格                cell.setCellValue(va.toString());// 寫入當(dāng)前日期                cell.setCellStyle(style);// 應(yīng)用樣式對(duì)象                j++;            }            i++;        }        String fileName = "列表"+"-"+DateUtil.dateToDateString(new Date(),DateUtil.yyyy_MM_dd_HH_mm_ss_CN);        fileName = URLEncoder.encode(fileName, "UTF-8");        // 文件輸出流        response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.concat(".").concat("xlsx").getBytes()));        OutputStream toClient = new BufferedOutputStream(response.getOutputStream());        response.setContentType("application/octet-stream");        workBook.write(toClient);// 將文檔對(duì)象寫入文件輸出流        toClient.flush();        toClient.close();    }