java实现excel表格导出,带有下拉框

java实现excel表格导出,带有下拉框 2022-06-22 962

需求: 需要做一个模板表格导出的接口,生成一个excel表格,并且设置带有下拉框的单元格

maven依赖

<dependency>
  <groupId>org.apache.poi</groupId>
     <artifactId>poi</artifactId>
     <version>4.1.2</version>
 </dependency>
 <dependency>
     <groupId>org.apache.poi</groupId>
     <artifactId>poi-ooxml</artifactId>
     <version>4.1.2</version>
 </dependency>

controller

@PostMapping("/downloadAdsourceTemplate")
    public void downloadAdsourceTemplate(@RequestBody AdSourceVo vo,HttpServletResponse response) throws IOException {
          
   
        Workbook workbook = aggregateService.downloadAdsourceTemplate(vo);
        String excelName = "批量导入代码位模板.xlsx";
        response.setContentType("application/octet-stream");
        // 指定下载的文件名
        response.setHeader("content-Disposition", "attachment;filename=" + excelName);
        response.flushBuffer();
        workbook.write(response.getOutputStream());
    }