jsp动态生成的表格导出excel的方法

Question

exceljsp导出

Answer 1

response.setContentType("application/msexcel");
                response.setHeader("Content-disposition",
                                "inline; filename=data.xls"); //attachment
                DownExcel excel = new DownExcel();
                HSSFWorkbook wb = excel.downExcel(deviceType);
                OutputStream os = response.getOutputStream();
                wb.write(os);
                os.flush();
                os.close();
                out.clear();
                out = pageContext.pushBody();