Excel导入优先推荐easyExcel和easypoi
easyExcel:https://alibaba-easyexcel.github.io/
easyPoi:http://easypoi.mydoc.io/
poi文档(在谷歌浏览器上可翻译):http://poi.apache.org/apidocs/index.html
==============================================
@Controller
@PostMapping("/import")
public R importExcel(MultipartFile file) {
List<List> Strings=excelUtilBySeatQuota.importExpress(file);
if (Strings.isEmpty()){
System.out.println("文件内容为空");
}
System.out.println(Strings.toString());
return R.ok();
}
@Service
package com.bjc.sys.admin.service.impl;
import com.alibaba.fastjson.JSON;
import io.micrometer.core.instrument.MultiGauge;
import javafx.beans.property.ReadOnlyB