java读取excel所有页的数据

package com.jbit.demo; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.PrintStream; import java.util.ArrayList; import java.util.HashMap; import java.util.LinkedHashMap; import java.util.List; import java.util.Map; import java.util.Set; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.DateUtil; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; /** * * @author 倪广勋 * Date 2018/9/18 * Phone 17562717906 * Remark 01年的java程序员 年龄小找工作不易啊 * Address 山东 */ public class excelUtil { public static Map<String, Map<Integer, Map<Integer, String>>> readExcelToMap(String excelFilePath) { Workbook wb = null; Sheet sheet = null; Row row = null; // 声明所有页的集合 Map<String, Map<Integer, Map<Integer, String>>> mapSheet = new LinkedHashMap<>(); wb = readExcel(excelFilePath); if (wb != null) { // 获取总页数 int pageSize = wb.getNumberOfSheets(); for (int i = 0; i < pageSize; i++) { // 声明当前页的行和列 Map<Integer, Map<Integer, String>> map = new HashMap<>(); // 获取当前页 sheet = wb.getSheetAt(i); String sheetName = sheet.getSheetName(); // System.out.println("获取当前页的最大行数"); int rowSize = sheet.getPhysicalNumberOfRows(); // System.out.println("遍历所有行"); for (int j = 0; j < rowSize; j++) { // System.out.println("获取第"+j+"行"); row = sheet.getRow(j); // System.out.println("获取当前页的最大列数"); int columnSize = row.getPhysicalNumberOfCells(); // 声明当前列 Map<Integer, String> columnMap = new HashMap<>(); for (int j2 = 0; j2 < columnSize; j2++) { // System.out.println("获取第"+j2+"列的内容"); String value = (String) getCellFormatValue(row.getCell(j2)); // 添加当前列的内容 j2代表第几列 value是内容 columnMap.put(j2, value); } // 添加当前行的内容 j代表第几行 value是列的内容 意思是第几行第几列的内容 map.put(j, columnMap); } // 添加当前页的所有内容 mapSheet.put(sheetName, map); } } return mapSheet; } // 读取excel private static Workbook readExcel(String filePath) { Workbook wb = null; if (filePath == null) { return null; } String extString = filePath.substring(filePath.lastIndexOf(".")); InputStream is = null; try { is = new FileInputStream(filePath); if (".xls".equals(extString)) { return wb = new HSSFWorkbook(is); } else if (".xlsx".equals(extString)) { return wb = new XSSFWorkbook(is); } else { return wb = null; } } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } return wb; } private static Object getCellFormatValue(Cell cell) { Object cellValue = null; if (cell != null) { // 判断cell类型 switch (cell.getCellType()) { case Cell.CELL_TYPE_NUMERIC: { cellValue = String.valueOf(cell.getNumericCellValue()); break; } case Cell.CELL_TYPE_FORMULA: { // 判断cell是否为日期格式 if (DateUtil.isCellDateFormatted(cell)) { // 转换为日期格式YYYY-mm-dd cellValue = cell.getDateCellValue(); } else { // 数字 cellValue = String.valueOf(cell.getNumericCellValue()); } break; } case Cell.CELL_TYPE_STRING: { cellValue = cell.getRichStringCellValue().getString(); break; } default: cellValue = ""; } } else { cellValue = ""; } return cellValue; } }