@PostMapping(“/imp”)
public String imp(@RequestPart(“filePath”) MultipartFile filePath) {
//创建一个excel文件
HSSFWorkbook workbook = null;
try {
workbook = new HSSFWorkbook(filePath.getInputStream()); //获取文件
Sheet sheet = workbook.getSheetAt(0); //获取第一个工作表
//循环工作表的数据
//getLastRowNum() 获取行
for (int i = 0; i < sheet.getLastRowNum(); i++) {
Row row = sheet.getRow(i + 1); //下表是从0开始的所以 把行数设置为第二行从第二行开始读
Cell cell = row.getCell(0); //获取第一个单元格,以此类推
Cell cel2 = row.getCell(1);
Cell cel3 = row.getCell(2);
Cell cel4 = row.getCell(3);
Cell cel5 = row.getCell(4);
//获取值
int id = (int) cell.getNumericCellValue();
String name = cel2.toString();
String sex = cel3.toString();
String education = cel4.toString();
int monthly = (in