java读取xlsx_Java读取Excel文件（支持xls，xlsx，多sheet）

public classExcelReadUtil {private static Logger logger = LoggerFactory.getLogger(ExcelReadUtil.class);public static HashMap>> readExcel(File file, intignoreRow) {if (file.getName().toLowerCase().endsWith(".xlsx")) {returnreadExcelForXlsx(file, ignoreRow);

}else if (file.getName().toLowerCase().endsWith(".xls")) {returnreadExcelForXls(file, ignoreRow);

}return null;

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

*

*@paramfile*/

private static HashMap>> readExcelForXlsx(File file, intignoreRow) {

HashMap>> map = new HashMap<>();if (!file.exists()) {

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

}int rowSize = 0;try (BufferedInputStream in = new BufferedInputStream(newFileInputStream(file))) {

XSSFWorkbook workbook= null;try{

workbook= newXSSFWorkbook(in);

<