JAVA分批读取excle_Java读取Excel文件（支持xls，xlsx，多sheet）

1. pom.xml依赖

org.apache.poi

poi

4.0.1

org.apache.poi

poi-ooxml

4.0.1

org.apache.poi

poi-ooxml-schemas

4.0.1

2. 工具类封装

public class ExcelReadUtil {

private static Logger logger = LoggerFactory.getLogger(ExcelReadUtil.class);

public static HashMap>> readExcel(File file, int ignoreRow) {

if (file.getName().toLowerCase().endsWith(".xlsx")) {

return readExcelForXlsx(file, ignoreRow);

} else if (file.getName().toLowerCase().endsWith(".xls")) {

return readExcelForXls(file, ignoreRow);

}

return null;

}

/**

* 读取Excel xlsx后缀名文件数据

*

* @param file

*/

private static HashMap>> readExcelForXlsx(File file, int ignoreRow) {

HashMap>> map = new HashMap<>();

if (!file.exists()) {

logger.error("{}文件不存在", file.getName());

return null;

}

int rowSize = 0;

try (BufferedInputStream in = new BufferedInputStream(new FileInputStream(file))) {

XSSFWorkbook workbook = null;

try {

workbook = new XSSFWorkbook(in);

} catch (IOException e) {

e.printStackTrace();

}

XSSFCell cell = null;

for (int sheetIndex &