根据上传的Excel，拿到不同的sheet解析后打包为zip下载 @PostMapping("/upload") @ResponseBody public String uploadFile(MultipartFile file, HttpServletResponse response) throws IOException { Map<String, XSSFWorkbook> map = parseJLLService.ParseJLLExcel(file); String originalFilename = file.getOriginalFilename(); originalFilename = originalFilename.substring(0,originalFilename.lastIndexOf("."))+".zip"; //初始化返回 Set<String> fileNames = map.keySet(); // ZipInputStream zipInputStream= null; response.reset(); res.... 批量生成Excel，打包成zip后下载 Java
MVAEN依赖 <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>4.0.1</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>4.0.1</version> </dependency> <dependency> 读取Excel （1）读取Excel InputStream inputStream = file.getInputStream(); XSSFWorkbook xssfWorkbook = new XSSFWorkbook(inputStream); （2）获取sheet的个.... Java POI Java
Wu's Blog