POM文件引入依赖包
<!-- Excel -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.14</version>
</dependency>
前端实例代码:
<!DOCTYPE html>
<html>
<head>
<#assign ctx = request.contextPath />
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="${ctx}/label/importTag" enctype="multipart/form-data" method="post">
<span style="white-space:pre"> </span><input type="file" name="file"/>
<span style="white-space:pre"> </span><input type="submit" value="导入"/>
<span style="white-space:pre"> </span>
</form>
</body>
</html>
后端java代码:
@RequestMapping(value="importTag")
public void importUser(HttpServletRequest request, HttpServletResponse response, MultipartFile file){
try {
InputStream is = file.getInputStream();
XSSFWorkbook wb = new XSSFWorkbook(is);//xslx
XSSFSheet sheet= wb.getSheetAt(0); //sheet 从0开始
int rowNum = sheet.getLastRowNum() + 1; //取得最后一行的行号
Date date = new Date();
int all=0;
for (int i = 0; i < rowNum; i++) { //行循环开始
XSSFRow row = sheet.getRow(i); //行
String tagId = getcellvalue(row.getCell(0));
String tagName= getcellvalue(row.getCell(1));
String pTagid= getcellvalue(row.getCell(2));
/* TAG tag = new TAG();
tag.setTagName(tagName);
tag.setPTagid(pTagid);
tag.setTagId(tagId);
tag.setCreateUser("admin");
tag.setModifyUser("admin");
tag.setCreateDate(date);
tag.setModifyDate(date);
tag.setTagClassNo("2");
tag.setTagClassName("22");
tag.setStatus("1");
int count =labelService.addLabel(tag);
all=all+count;*/
}
} catch (Exception e) {
System.out.println(e);
}
private static String getcellvalue(Cell cell){
String cellValue = "";
if (null != cell) {// 判断excel单元格内容的格式,并对其进行转换,以便插入数据库
switch (cell.getCellType()) {
case 0:
cellValue = String.valueOf((int) cell.getNumericCellValue());
break;
case 1:
cellValue = cell.getStringCellValue();
break;
case 2:
cellValue = cell.getNumericCellValue() + "";
// cellValue = String.valueOf(cell.getDateCellValue());
break;
case 3:
cellValue = "";
break;
case 4:
cellValue = String.valueOf(cell.getBooleanCellValue());
break;
case 5:
cellValue = String.valueOf(cell.getErrorCellValue());
break;
}
}
return cellValue.trim();
}