XSSFWorkbook获取excel的值，封装成list集合

/** * @param wb excel * @return sheet集合<row集合<cell集合，全转为String类型>> */ public static List<List<List<String>>> getExcelData(XSSFWorkbook wb){ int numSheets = wb.getNumberOfSheets(); List<List<List<String>>> sheets = new ArrayList<>(); //sheet for(int i=0;i<numSheets;i++){ XSSFSheet sheet = wb.getSheetAt(i); System.out.println(sheet.getSheetName()); int numRows = sheet.getLastRowNum(); List<List<String>> rows = new ArrayList<>(); //row for (int j=0;j<numRows;j++){ XSSFRow row = sheet.getRow(j); if (row==null){ break; } int numCells = row.getLastCellNum(); List<String> cells = new ArrayList<>(); //cell for (int k=0;k<numCells;k++){ cells.add(getValue(k,row)); } rows.add(cells); } sheets.add(rows); } return sheets; } /** * 获取指定位置的数据值，全转为string * @param rowNum 所属行， 第一行为0 * @param colNum 所诉列， 第一列为0 * @return 值 */ public static String getValue(int rowNum, int colNum, XSSFSheet sheet){ XSSFRow row = sheet.getRow(rowNum); return getValue(colNum, row); } public static String getValue(int colNum, XSSFRow row){ XSSFCell cell = row.getCell(colNum); if (cell==null){ return ""; } String cellValue = ""; CellType cellTypeEnum = cell.getCellTypeEnum(); try { DecimalFormat df = new DecimalFormat("0.00"); if (cell.getCellTypeEnum() == CellType.NUMERIC) { if (HSSFDateUtil.isCellDateFormatted(cell)) { cellValue = DateFormatUtils.format(cell.getDateCellValue(), "yyyy-MM-dd"); } else { NumberFormat nf = NumberFormat.getInstance(); cellValue = String.valueOf(nf.format(cell.getNumericCellValue())).replace(",", ""); } } else if (cell.getCellTypeEnum() == CellType.STRING) { cellValue = String.valueOf(cell.getStringCellValue()); } else if (cell.getCellTypeEnum() == CellType.BOOLEAN) { cellValue = String.valueOf(cell.getBooleanCellValue()); } else if (cell.getCellTypeEnum() == CellType.ERROR) { cellValue = "错误类型"; } else if (cell.getCellTypeEnum() == CellType.FORMULA) {//公式类型 cellValue = df.format(cell.getNumericCellValue());//将公式类型的值转成保留两位小数的数字 // cellValue = String.valueOf(cell.getArrayFormulaRange().getNumberOfCells()); } else { cellValue = ""; } }catch (Exception e){ logger.error(e.getMessage(),e); cellValue = "-9999999999"; } return cellValue; }