excel读取 hutool_Mr · 范

Java

hutool读excel

2021-02-19

13次浏览

# 启动

```java

/**

* 导入

*/

@RequestMapping("/excel")

public JSONObject deal(HttpServletRequest request, @RequestParam("file") MultipartFile file) {

// 1.获取上传文件输入流

InputStream inputStream = null;

try {

inputStream = file.getInputStream();

} catch (Exception e) {

e.printStackTrace();

}

System.out.println(inputStream);

// 2.应用HUtool ExcelUtil获取ExcelReader指定输入流和sheet

ExcelReader excelReader = ExcelUtil.getReader(inputStream, 0);

// 可以加上表头验证

// 3.读取第二行到最后一行数据

List userBaseInfoExcelContents = excelReader.readAll(UserBaseInfoExcelContent.class);

userBaseInfoExcelContents.remove(0);

System.out.println(userBaseInfoExcelContents);