java后台导出excel，客户端下载

深碍√TFBOYSˉ_ 2022-09-30 09:39 176阅读 0赞

function exportFun(){
    	    var urlDownload = '${ctx}/filemanager/termInfo/export';//请求生成excel地址
    		var datas = '?serial=123&airVersionName=TEST&cityName=喜乐航';
    		window.open(urlDownload+datas);
    }

@RequestMapping("/termInfo/export")
     public void termInfoExport(TermInfo bean,String begintime,String endtime,String type,HttpServletResponse response,HttpServletRequest request) {

response.setContentType("application/msexcel;charset=UTF-8");

response.addHeader("Content-Disposition", "attachment;filename=\""+ new String(("export.xlsx").getBytes("GBK"), "ISO8859_1") + "\"");

OutputStream sos = null;
       sos = response.getOutputStream();

XSSFWorkbook templatewb = null;     Sheet tempSheet = null;     int num = 1;//从第几行还是写入数据  0为第一行1为第二行     int cellnum = 0; //    OutputStream output =null;//文件导出流     try {      //output=new FileOutputStream(new File(fileName));      //String modelName = templateName;// 获取模版      // 获取模板      templatewb = new XSSFWorkbook(new FileInputStream(new File(templateName)));      tempSheet = templatewb.getSheetAt(0);//获取第一个sheet页      //设置样式      CellStyle style = templatewb.createCellStyle();      // 获取模板sheet页      style.setAlignment(HorizontalAlignment.CENTER);      style.setVerticalAlignment(VerticalAlignment.CENTER);      // 增加表格边框的样式 例子      style.setBorderBottom(BorderStyle.THIN);      style.setBorderLeft(BorderStyle.THIN);// 左边框      style.setBorderRight(BorderStyle.THIN);// 右边框      style.setBorderTop(BorderStyle.THIN);// 上边框            Font font = templatewb.createFont();      font.setFontName("新宋体");      font.setFontHeightInPoints((short) 9);// 字体大小      style.setFont(font); // 调用字体样式对象      style.setWrapText(true);      // 将数据写入excel      for (int i = 0; i < dataList.size(); i++) {       Row row = tempSheet.createRow(num++);       row.setHeightInPoints(22); // 设置行高       Map<String, Object> dataMap = dataList.get(i);       cellnum = -1;       // 排名       Cell cellNum = row.createCell(++cellnum);       cellNum.setCellValue(i+1);       cellNum.setCellStyle(style);       // 终端编号       Cell serial = row.createCell(++cellnum);       serial.setCellValue((String)dataMap.get("serial"));       serial.setCellStyle(style);       Cell mac = row.createCell(++cellnum);       mac.setCellValue((String)dataMap.get("mac"));       mac.setCellStyle(style);       Cell airVersionName = row.createCell(++cellnum);       airVersionName.setCellValue((String)dataMap.get("airVersionName"));       airVersionName.setCellStyle(style);       // 终端编号       Cell cityName = row.createCell(++cellnum);       cityName.setCellValue((String)dataMap.get("cityName"));       cityName.setCellStyle(style);      }      // 将内容写入Excel      templatewb.write(sos);     } catch (Exception e) {      e.printStackTrace();     } finally {      try {       sos.close();      } catch (IOException e) {       e.printStackTrace();      }     }     return "";