Java导出excel表格

前端直接get请求即可

service接口

HSSFWorkbook expExcel(String date, HttpServletResponse response)

service层

@Override
public HSSFWorkbook expExcel(String date, HttpServletResponse response) {
        System.out.println(date+"------------");
        System.out.println(date+"------------");
        date="{'date':'"+date+"'}";
        System.out.println(date+"------------");
        System.out.println(date+"------------");
        //创建一个新的Excel
        HSSFWorkbook workBook = new HSSFWorkbook();
        //创建sheet页
        HSSFSheet sheet = workBook.createSheet();
        //sheet页名称
        workBook.setSheetName(0, "xxx数据下载");
        //创建header页
        HSSFHeader header = sheet.getHeader();
        //设置标题居中
        header.setCenter("标题");
        //设置第一行为Header
        HSSFRow row = sheet.createRow(0);
        // HSSFCell cell0 = row.createCell(Short.parseShort("0"));
        HSSFCell cell1 = row.createCell(Short.parseShort("0"));
        HSSFCell cell2 = row.createCell(Short.parseShort("1"));
        HSSFCell cell3 = row.createCell(Short.parseShort("2"));
        HSSFCell cell4 = row.createCell(Short.parseShort("3"));
        HSSFCell cell5 = row.createCell(Short.parseShort("4"));

        //表头
        cell1.setCellValue("标题1");
        cell2.setCellValue("标题2");
        cell3.setCellValue("标题3");
        cell4.setCellValue("标题4");
        cell5.setCellValue("标题5");
        sheet.setColumnWidth((short) 0, (short) 4000);
        sheet.setColumnWidth((short) 1, (short) 4000);
        sheet.setColumnWidth((short) 2, (short) 4000);
        sheet.setColumnWidth((short) 3, (short) 20000);
        sheet.setColumnWidth((short) 4, (short) 4000);
        JSonArray xqOther = this.getXqOther(date)//获取需要导出的内容
        if (xqOther != null && xqOther.size() > 0){
                List