关于org.apache.poi.ss.usermodel 操作excel数据丢失问题

今日测试发现excel 有一列为空 会导致后面的列数据丢失 特此记录一下修改的bug      
      
//获得当前sheet工作表
            Sheet sheet = workbook.getSheetAt(sheetNum);
            if (sheet == null) {
               continue;
            }
            //获得当前sheet的开始行
            int firstRowNum = sheet.getFirstRowNum();
            //获得当前sheet的结束行
            int lastRowNum = sheet.getLastRowNum();
            //循环除了第一行的所有行
            for (int rowNum = firstRowNum + 1; rowNum <= lastRowNum; rowNum++) {
               //获得当前行
               Row row = sheet.getRow(rowNum);
               if (row == null) {
                  continue;
               }
               //获得当前行的开始列
               //row.getFirstCellNum() 数据只能从第一列非空的读取 要漏数据 被这行代码坑了
               int lastCellNum = row.getLastCellNum();
               //获得当前行的列数
//             int lastCellNum = row.getPhysicalNumberOfCells();
               String[] cells = new String[lastCellNum];
               //循环当前行
               for (int cellNum = 0; cellNum < lastCellNum; cellNum++) {
//这行是原来的取值方法,罪魁祸首就是这个 firstCellNum =row.getFirstCellNum()  ;lastCellNum=row.getPhysicalNumberOfCells()
//             for (int cellNum = firstCellNum; cellNum < lastCellNum; cellNum++) { 
                  Cell cell = row.getCell(cellNum);
                  cells[cellNum] = getCellValue(cell);
               }
               list.add(cells);

public static String getCellValue(Cell cell) {
   String cellValue = "";
   if (cell == null) {
      return cellValue;
   }
   //把数字当成String来读，避免出现1读成1.0的情况
   if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
      cell.setCellType(Cell.CELL_TYPE_STRING);
   }
   //判断数据的类型
   switch (cell.getCellType()) {
      case Cell.CELL_TYPE_NUMERIC: //数字
         cellValue = String.valueOf(cell.getNumericCellValue());
         break;
      case Cell.CELL_TYPE_STRING: //字符串
         cellValue = String.valueOf(cell.getStringCellValue());
         break;
      case Cell.CELL_TYPE_BOOLEAN: //Boolean
         cellValue = String.valueOf(cell.getBooleanCellValue());
         break;
      case Cell.CELL_TYPE_FORMULA: //公式
         cellValue = String.valueOf(cell.getCellFormula());
         break;
      case Cell.CELL_TYPE_BLANK: //空值
         cellValue = "";
         break;
      case Cell.CELL_TYPE_ERROR: //故障
         cellValue = "非法字符";
         break;
      default:
         cellValue = "未知类型";
         break;
   }
   return cellValue;
}