解析表格Excel内容到数据库中
一、使用步骤
1.引入库
代码如下(示例):
<!--读取excel文件-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.10-FINAL</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.14</version>
</dependency>
2.读入数据
代码如下(示例):
我的结构没有加mapper,只是演示
Controller
public class PoiController {
@Autowired
private AdminServiceImpl adminService;
@RequestMapping("poi")
public void poi(MultipartFile multipartFile) {
List<User> list = adminService.upExcel(multipartFile);
System.out.println(list);
}
}
Service
public class AdminServiceImpl {
public List<User> upExcel(MultipartFile multipartFile) {
List<User> users = new ArrayList<User>();
try {
List<String[]> list = ExcelUtil.readExcel(multipartFile);
if (list != null && list.size() > 0) {
for (int i = 0; i < list.size(); i++) {
User user = new User();
if (list.get(i)[0] != null && list.get(i)[0] != "") {
for (int j = 0; j < list.get(i).length; j++) {
switch (j) {
case 0: {
//姓名