使用hutool实现Excel导入导出
引入pom文件
cn.hutool
hutool-all
4.6.10
org.apache.poi
poi-ooxml
3.17-beta1
xerces
xercesImpl
2.12.0
导入 Excel
将excel 中的内容添加到list集合当中list泛型为object
inputStream ->流
//conroller 接收参数
@RequestParam(value = “file”, required = false) MultipartFile file
//获取到流 传输到 service层
InputStream inputStream = file.getInputStream();
List<List> list = new ArrayList<List>();
Excel07SaxReader reader = new Excel07SaxReader(createRowHandler(list));
reader.read(inputStream, 0);
list.for 进行自己业务逻辑代码 存表什么的
private static RowHandler createRowHandler(final List<List> list) {
return new RowHandler() {
public void hand