/**
* 获取excel文件所有sheet页
*
* @param inputStream
* @return java.util.List<com.alibaba.excel.read.metadata.ReadSheet>
* @author
* @date 2022/3/29 11:09 上午
*/
public static List<ReadSheet> listSheet(InputStream inputStream) {
if (inputStream == null) {
throw new RuntimeException("inputStream is null");
}
ExcelReader build = EasyExcel.read(inputStream)
.build();
List<ReadSheet> readSheets = build.excelExecutor()
.sheetList();
log.info(String.valueOf(readSheets));
return readSheets;
}
EasyExcel获取excel文件中sheet页总数,及对应sheet页名称及下标
于 2022-03-29 16:15:31 首次发布