多应用+插件架构,代码干净,二开方便,首家独创一键云编译技术,文档视频完善,免费商用码云13.8K 广告
```java @RequestMapping("/excel/read") public void read(@RequestParam("file") MultipartFile file) throws IOException { //创建文档 XSSFWorkbook workbook = new XSSFWorkbook(file.getInputStream()); //获取表格 XSSFSheet sheet = workbook.getSheetAt(0); //获取总行数 int rows = sheet.getPhysicalNumberOfRows(); for (int i = 0; i < rows; i++) { //获取行 XSSFRow row = sheet.getRow(i); //获取每一行的总列数 int cols = row.getPhysicalNumberOfCells(); for (int k = 0; k < cols; k++) { //获取列 XSSFCell cell = row.getCell(k); //获取值 String value = cell.toString(); System.out.println(value); } } } ```