java中导出Excel（超实用）

java中导出Excel（超实用）：

还是老样子，分享下简单的技术这样平常也可以随用随取了。希望能帮得到大家！！！上！代！码！。这个excel导出的相对来说可能比较繁琐，大家有更好的希望分享一下，一起学习。

1. 整理了一个工具类

private static int writeTitlesToExcel(XSSFWorkbook wb, Sheet sheet, List<String> titles, XSSFCellStyle titleStyle) {
   
        int rowIndex = 0;
        int colIndex = 0;
        try {
   
            Row titleRow = sheet.createRow(rowIndex);
            titleRow.setHeightInPoints(25);

            for (String field : titles) {
   
                Cell cell = titleRow.createCell(colIndex);
                cell.setCellValue(field);
                cell.setCellStyle(titleStyle);
                colIndex++;
            }
        } catch (Exception e) {
   
            e.printStackTrace();
        }
        return ++rowIndex;
    }

    // 设置response
    public HttpServletResponse setResponse(HttpServletResponse response, String exportFileName) throws Exception {
   
        // 告诉浏览器用什么软件可以打开此文件，定义输出类型
        response.setHeader("content-Type", "application/vnd.ms-excel");
        //response.setContentType("application/msexcel");
        // 下载文件的默认名称
        response.setHeader("Content-Disposition", "attachment;filename=" + java.net.URLEncoder.encode(exportFileName, "UTF-8"));
        return response;
    }

    // 获取工作表
    public Sheet getSheetAt(XSSFWorkbook wb, int num) throws Exception {
   
        Sheet sheet = null;
        try {
   
            Integer sheetCount = wb.getNumberOfSheets();
            if (sheetCount == 0) {
   
                sheet = wb.createSheet("Sheet1");
            } else {
   
                sheet = wb.getSheetAt(num);
            }
        } catch (Exception e) {
   
            e.printStackTrace();
        }
        return sheet;
    }

    //时间字段格式化
    private String getFormatDateString(Date date, String format) {
   
        try {
   
            SimpleDateFormat sdf = new SimpleDateFormat(format);
            return sdf.format(date);
        } catch