java导出excel

页面查询到的数据 怎么导出到excel 要可以 单选/多选/全部 导出

这个前端做比较合适

• 这个问题的回答你可以参考下: https://ask.csdn.net/questions/7531284
• 这篇博客你也可以参考下：java代码导出excel支持数据有效性验证，即excel单元格可以下拉选择
• 除此之外, 这篇博客: java导出excel接口(附效果图)中的 内网审批记录结果表导出excel 部分也许能够解决你的问题, 你可以仔细阅读以下内容或跳转源博客中阅读:
  

• @RequestMapping("/excel")
  @RestController
  @Api(tags = "导出Excel @ 季瓜", description = "ExcelController")
  public class ExcelController {
  
      private static final Logger loggger = LoggerFactory.getLogger(ExcelController.class);
  
      @Resource
      private OperationService operationService;
  
      @PostMapping("/excelDownload")
      @ApiOperation("导出excel")
      public void excelDownload(HttpServletResponse response, @RequestBody SelectUser selectUser) {
  
          HSSFWorkbook workbook = new HSSFWorkbook();
          HSSFSheet sheet = workbook.createSheet("审批记录导出");
  		
  		//获取需要导出的数据
          List<ReasonDTO> list = operationService.getAllOperation(selectUser.getTimeStart(),selectUser.getTimeEnd());
  
          int insertRows = 0;
  
          for (int i = 0 ; i < list.size() ; i++){
              Row titileRow = sheet.createRow(insertRows);
              titileRow.createCell(0).setCellValue("申请人:");
              titileRow.createCell(1).setCellValue(list.get(i).getName());
              titileRow.createCell(2).setCellValue("审批人:");
              titileRow.createCell(3).setCellValue(list.get(i).getApprovalName());
              titileRow.createCell(4).setCellValue("审批时间:");
              titileRow.createCell(5).setCellValue(list.get(i).getApprovalTime());
              CellRangeAddress rangeAddress = new CellRangeAddress(insertRows,insertRows,5,6);
              sheet.addMergedRegion(rangeAddress);
              titileRow.createCell(8).setCellValue("审批结果:");
              titileRow.createCell(9).setCellValue(list.get(i).getApprovalResult());
              insertRows++;
  
              Row titileRow1 = sheet.createRow(insertRows);
              titileRow1.createCell(0).setCellValue("文件名:");
              CellRangeAddress rangeAddress1 = new CellRangeAddress(insertRows,insertRows,1,2);
              sheet.addMergedRegion(rangeAddress1);
              titileRow1.createCell(1).setCellValue(list.get(i).getFileName());
              titileRow1.createCell(3).setCellValue("文件大小:");
              CellRangeAddress rangeAddress2 = new CellRangeAddress(insertRows,insertRows,4,6);
              sheet.addMergedRegion(rangeAddress2);
              titileRow1.createCell(4).setCellValue(list.get(i).getFileSize());
              insertRows++;
  
              Row titileRow2 = sheet.createRow(insertRows);
              titileRow2.createCell(0).setCellValue("申请原因:");
              CellRangeAddress rangeAddress3 = new CellRangeAddress(insertRows,insertRows,1,9);
              sheet.addMergedRegion(rangeAddress3);
              titileRow2.createCell(1).setCellValue(list.get(i).getReason());
              insertRows++;
  
              CellRangeAddress rangeAddress4 = new CellRangeAddress(insertRows,insertRows,0,9);
              sheet.addMergedRegion(rangeAddress4);
  
              insertRows++;
          }
  
  
          OutputStream outputStream = null;
  
          try {
              String fileName = "审批记录";
              response.setCharacterEncoding("UTF-8");
              response.setContentType("application/vnd.ms-excel");
              response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode(fileName + ".xls","utf-8"));
              outputStream = response.getOutputStream();
              workbook.write(outputStream);
              outputStream.flush();
              outputStream.close();
              workbook.close();
              loggger.info("导出文件:" + DateUtil.dataToString(new Date()));
          } catch (Exception e) {
              loggger.error("导出文件错误:" + e.getMessage());
          }
      }
  

  

• 您还可以看一下 邱石老师的java后台+微信小程序 实现完整的点餐系统课程中的 菜品和订单数据导出到excel效果演示小节, 巩固相关知识点
  

前端做成表单提交
后端用poi给提交上来数据，输出到excel表格