hutool读取Excel内容
需要引入依赖
<dependency> <groupId>cn.hutool</groupId> <artifactId>hutool-all</artifactId> <version>5.4.7</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.16</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.16</version> </dependency>
代码:
package com.java.test; import cn.hutool.poi.excel.ExcelReader; import cn.hutool.poi.excel.ExcelUtil; import org.apache.poi.util.IOUtils; import org.junit.Test; import org.springframework.mock.web.MockMultipartFile; import org.springframework.web.multipart.MultipartFile; import java.io.File; import java.io.FileInputStream; import java.io.InputStream; import java.util.List; /** * @author AiQ * @date 2021/1/8 * @describe: */ public class TestHutool { @Test public void test() throws Exception{ File file = new File("G:\\AiQ.xlsx"); FileInputStream input = new FileInputStream(file); MultipartFile multipartFile =new MockMultipartFile("file", file.getName(), "text/plain", IOUtils.toByteArray(input)); // 1.获取上传文件输入流 InputStream inputStream = null; try{ inputStream = multipartFile.getInputStream(); }catch (Exception e){ } // 2.应用HUtool ExcelUtil获取ExcelReader指定输入流和sheet ExcelReader excelReader = ExcelUtil.getReader(inputStream, "代理"); // 可以加上表头验证 // 3.读取第二行到最后一行数据 List<List<Object>> read = excelReader.read(2, excelReader.getRowCount()); for (List<Object> objects : read) {
// 获取指定的的数据
} } }
踏踏实实的走,每一步都算数
posted on 2021-01-08 01:01 放弃容易坚持一定很帅 阅读(3952) 评论(0) 编辑 收藏 举报