import com.alibaba.excel.EasyExcelFactory; import com.alibaba.excel.ExcelReader; import com.alibaba.excel.context.AnalysisContext; import com.alibaba.excel.event.AnalysisEventListener; import java.io.InputStream; import java.util.ArrayList; import java.util.List; import java.util.Map; /** * excel读写工具类 * * @author shenjian * @since 2021/07/12 */ public class ExcelUtils { public static List> read(InputStream inputStream) { SimpleExcelListener listener = new SimpleExcelListener(); ExcelReader excelReader = EasyExcelFactory.read(inputStream, null, listener) .headRowNumber(1).build(); excelReader.readAll(); List> dataList = listener.getDataList(); excelReader.finish(); return dataList; } public static class SimpleExcelListener extends AnalysisEventListener { private List> dataList = new ArrayList<>(); @Override public void invoke(Object o, AnalysisContext analysisContext) { Map map = (Map) o; dataList.add(new ArrayList<>(map.values())); } @Override public void doAfterAllAnalysed(AnalysisContext analysisContext) { } List> getDataList() { return dataList; } void setDataList(List> dataList) { this.dataList = dataList; } } }