java 动态导出excel表单无模板文件下载-白红宇

java 动态导出excel表单无模板文件下载

阅读量：3965 次

发布时间：2019-05-24

本文共 1803 字，大约阅读时间需要 6 分钟。

java 动态导出excel表单无模板文件下载

public ResponseEntity
   
     exportStanding(@PathVariable Long signupId) throws IOException {    MettingSignup mettingSignup = mettingSignupService.getById(signupId);    Meeting meeting = meetingService.getById(mettingSignup.getMeetingId());    List
    
     
      >  mapLists = signupUserinfoService.selectBySignupId(signupId,1,1000);    //上面是获取数据，根据自己不同需求去获取不同数据    // 创建工作薄    HSSFWorkbook workbook = new HSSFWorkbook();    // 创建用户工作表    HSSFSheet sheet = workbook.createSheet("报名用户");    //创建行    HSSFRow rows = sheet.createRow(0);    // 动态添加 表头 headList --> 所有表头行集合    List
      
       
        > headList = new ArrayList
        
         
          >(); List
           mapList = formTemplateService.selectFormTitleBySignupId(signupId); // 第 n 行 的表头 int j=0; for (Map map:mapList) { //创建列 rows.createCell(j).setCellValue((String) map.get("form_title")); j++; } j=1; // 第 n 行的数据 for (Map
           
             maps : mapLists) { HSSFRow rowss = sheet.createRow(j); int i=0; for (Map map:mapList) { //创建列 rowss.createCell(i).setCellValue((String)maps.get(map.get("form_title"))); i++; } j++; } //字节输出流 ByteArrayOutputStream outputStream = new ByteArrayOutputStream(); try { workbook.write(outputStream); } catch (IOException e) { e.printStackTrace(); } finally { outputStream.close(); } //http请求头 HttpHeaders httpHeaders = new HttpHeaders(); String name = meeting.getName()+".xls"; String fileName = new String(name.getBytes("UTF-8"), "iso-8859-1"); //设置内容属性 httpHeaders.setContentDispositionFormData("attachment", fileName); httpHeaders.setContentType(MediaType.APPLICATION_OCTET_STREAM); ResponseEntity
            
              filebyte = new ResponseEntity
             
              (outputStream.toByteArray(), httpHeaders, HttpStatus.CREATED); try { outputStream.close(); } catch (IOException e) { e.printStackTrace(); } finally { outputStream.close(); } return filebyte;}