需求说明:因为项目需求,请求头要做国际化,请求头随时更改,所以请求头为动态!
1.pom.xml引入
com.alibaba
easyexcel
2.监听引入EasyExcelListener import com.alibaba.excel.context.AnalysisContext; import com.alibaba.excel.event.AnalysisEventListener; import java.util.ArrayList; import java.util.List; import java.util.Map; public class EasyExcelListener extends AnalysisEventListener
3.工具类型生成EasyExcelImportUtils
import com.alibaba.excel.EasyExcelFactory;
import com.alibaba.excel.util.IoUtils;
import org.apache.commons.compress.utils.Lists;
import org.springframework.util.CollectionUtils;
import org.springframework.web.multipart.MultipartFile;
import java.io.*;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
public class EasyExcelImportUtils {
public static List> parseExcelToData(byte[] stream, Integer parseRowNumber) {
EasyExcelListener readListener = new EasyExcelListener();
EasyExcelFactory.read(new ByteArrayInputStream(stream)).registerReadListener(readListener).headRowNumber(parseRowNumber).sheet(0).doRead();
List> headList = readListener.getHeadList();
if(CollectionUtils.isEmpty(headList)){
throw new RuntimeException("Excel表头不能为空");
}
List> dataList = readListener.getDataList();
if(CollectionUtils.isEmpty(dataList)){
throw new RuntimeException("Excel数据内容不能为空");
}
//获取头部,取最后一次解析的列头数据
Map excelHeadIdxNameMap = headList.get(headList.size() -1);
//封装数据体
List> excelDataList = Lists.newArrayList();
for (Map dataRow : dataList) {
Map rowData = new LinkedHashMap<>();
excelHeadIdxNameMap.entrySet().forEach(columnHead -> {
rowData.put(columnHead.getValue(), dataRow.get(columnHead.getKey()));
});
excelDataList.add(rowData);
}
return excelDataList;
}
public static List> makeData(MultipartFile file){
InputStream inputStream = null;//转换成输入流
try {
inputStream = file.getInputStream();
} catch (IOException e) {
e.printStackTrace();
}
byte[] stream = new byte[0];
try {
stream = IoUtils.toByteArray(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
if(stream == null || stream.length == 0){
return null;
}
List> dataList = parseExcelToData(stream, 1);//从动态获取全部列和数据体,默认从第一行开始解析数据
try {
if(inputStream != null){
inputStream.close();
}
} catch (IOException e) {
e.printStackTrace();
}
return dataList;
}
public static void main(String[] args) throws IOException {
//属性项
FileInputStream inputStream = new FileInputStream(new File("C:\Users\Administrator\Desktop\easy_excel_test1.xlsx"));
byte[] stream = IoUtils.toByteArray(inputStream);
List> dataList = parseExcelToData(stream, 1);//动态获取全部列和数据体,默认从第一行开始解析数据
List objects = new ArrayList<>();
dataList.forEach(d->{
objects.addAll(d.keySet());
});
System.out.println("属性项:"+objects);
System.out.println("值:"+dataList);
inputStream.close();
}
}
4.控制层EasyExcelController
@RequestMapping
@RestController
public class EasyExcelController {
@PostMapping("toExportInt")
public Result toExceptInt(MultipartFile file){
List> list = EasyExcelImportUtils.makeData(file);
return Result.success(list);
}
}
积累一点点。。。。。。。。。。



