Java 导入Excel

1. springboot工程

• 引入依赖

<dependency>
    <groupId>net.sourceforge.jexcelapi</groupId>
    <artifactId>jxl</artifactId>
    <version>2.6.10</version>
</dependency>

2. 实现类

package com.example.demo.controller;

import jxl.Sheet;
import jxl.Workbook;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import java.util.ArrayList;
import java.util.List;

@RestController
public class ImportExcelController {

    @RequestMapping(value = "/importExcel")
    public void importExcel(@RequestParam("file") MultipartFile multipartFile) {

        try {
            Workbook workbook = Workbook.getWorkbook(multipartFile.getInputStream());
            Sheet sheet = workbook.getSheet(0);
            List<List<String>> strList = new ArrayList<>();
            int row = sheet.getRows();
            for (int i = 1; i < row; i++) {
                List<String> list = new ArrayList<>();
                String name = sheet.getCell(0,i).getContents().trim();
                String age = sheet.getCell(1,i).getContents().trim();
                String sex = sheet.getCell(2,i).getContents().trim();
                list.add(name);
                list.add(age);
                list.add(sex);
                strList.add(list);
            }
            System.out.println(strList);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

}

3. 创建一个excel表格(.xls)

4. 发起请求

5. 查看打印