@Resource
private CorporateActionExcelListener excelListener;
public void excel() {
InputStream inputStream;
try {
File source = new File("/Users/yaw/Documents/test.xlsx");
ByteSource byteSource = Files.asByteSource(source);
inputStream = byteSource.openStream();//用guava的io流操作,不需要使用者关闭流
} catch (FileNotFoundException e) {
return;
}
Map<String, String> customContent = Maps.newHashMap();
customContent.put("market", "HK");//传自定义参数到listener
ExcelReader excelReader = new ExcelReader(inputStream, customContent, excelListener, true);
List<Sheet> sheets = excelReader.getSheets();
for (Sheet sheet : sheets
easyExcel使用实例
最新推荐文章于 2024-06-12 15:43:10 发布