首先要使用hutool,可以加载maven
<dependency>
<groupId>com.xiaoleilu</groupId>
<artifactId>hutool-all</artifactId>
<version>3.3.2</version>
</dependency>
Controller使用方法
@ApiOperation(value = "导入excel员工")
@ResponseBody
@RequestMapping(value = "/importExcelEmp_1", method = RequestMethod.POST)
public ResponseVal importExcelEmp(HttpServletRequest request,
@RequestParam(value = "file", required = false) MultipartFile files, String comId) {
//DateFormat formater = new SimpleDateFormat("yyyy/MM/dd");
try{
//默认获取第一页
ExcelReader reader = ExcelUtil.getReader(files.getInputStream());
List<Map<String,Object>> readAll = reader.read(1,2,Integer.MAX_VALUE);
for (Map<String,Object> s:readAll) {
for (String k : s.keySet())
{
System.out.println("基本信息:"+k + " : " + s.get(k));
}
}
ExcelReader reader1 = ExcelUtil.getReader(files.getInputStream(), "教育经历");
/**
* headerRowIndex 标题所在行,如果标题行在读取的内容行中间,这行做为数据将忽略
* @param startRowIndex 起始行(包含,从0开始计数)
*/
List<Map<String,Object>> readAlls = reader1.read(1,2,Integer.MAX_VALUE);
for (Map<String,Object> s:readAlls) {
for (String k : s.keySet())
{
System.out.println("教育经历:"+k + " : " + s.get(k));
}
}
}catch (IOException e){
e.printStackTrace();
}
return null;
}