52 lines
1.4 KiB
Java
52 lines
1.4 KiB
Java
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<List<String>> read(InputStream inputStream) {
|
|
SimpleExcelListener listener = new SimpleExcelListener();
|
|
ExcelReader excelReader = EasyExcelFactory.read(inputStream, null, listener)
|
|
.headRowNumber(1).build();
|
|
excelReader.readAll();
|
|
List<List<String>> dataList = listener.getDataList();
|
|
excelReader.finish();
|
|
return dataList;
|
|
}
|
|
|
|
public static class SimpleExcelListener extends AnalysisEventListener {
|
|
private List<List<String>> dataList = new ArrayList<>();
|
|
|
|
@Override
|
|
public void invoke(Object o, AnalysisContext analysisContext) {
|
|
Map<String, String> map = (Map<String, String>) o;
|
|
dataList.add(new ArrayList<>(map.values()));
|
|
}
|
|
|
|
@Override
|
|
public void doAfterAllAnalysed(AnalysisContext analysisContext) {
|
|
|
|
}
|
|
|
|
List<List<String>> getDataList() {
|
|
return dataList;
|
|
}
|
|
|
|
void setDataList(List<List<String>> dataList) {
|
|
this.dataList = dataList;
|
|
}
|
|
}
|
|
}
|