导入数据 org.apache.poi.hssf.usermodel.HSSFWorkbook

HSSFWorkbook book = null;try {book = new HSSFWorkbook(file.getInputStream());} catch (IOException e) {log.error("导入的文件存在异常，无法转换为excel文件对象！",e);return 1;}HSSFSheet sheet = book.getSheetAt(0);int lastRowNum = sheet.getLastRowNum();log.info("sheet name:"+ sheet.getSheetName()+", lastRowNum:"+lastRowNum);if(lastRowNum < 1){return 2;}String username = UserSession.getUser().getUserName();List<DisableCustomer> disableCustomerList = new LinkedList<DisableCustomer>();for(int i=1;i<lastRowNum+1;i++){HSSFRow row = sheet.getRow(i);String cardNo = Common.getCellValue(row.getCell(0));if(StringUtils.isEmail(cardNo)){log.info("第【"+i+"】行月结卡号为空,结束读取操作,开始插入数据库.");break;}if(!Common.isCardNo(cardNo)){log.error("非法月结卡号:【" + cardNo+"】");return 3;}String reason = Common.getCellValue(row.getCell(1));if(StringUtils.isEmail(reason)){log.error("导入永久取消权限中数据中存在空值！");continue;}log.info("cardNo:"+cardNo+"reason:"+reason);disableCustomerList.add(new DisableCustomer(StringUtils.getUUID(32), cardNo, reason, username));}cancelPermissionsMapper.saveBatchDisableCustomer(disableCustomerList);log.info("list size:" + disableCustomerList.size());return 0;

/** * 获取表格的值（全部转换为String类型,长度超出100会截断） * @param cell * @return * @throws UnsupportedEncodingException  */public static String getCellValue(Cell cell) {String value;if(cell == null) return "";switch (cell.getCellType()) {    case Cell.CELL_TYPE_NUMERIC://数字      if(HSSFDateUtil.isCellDateFormatted(cell)){//是否为时间类型     Date d = cell.getDateCellValue();     DateFormat formater = new SimpleDateFormat("yyyy-MM-dd");     value = formater.format(d);    }else{    value = new DecimalFormat("#").format(cell.getNumericCellValue());    }        break;      case Cell.CELL_TYPE_STRING://字符串      value = cell.getStringCellValue().trim();        break;      case Cell.CELL_TYPE_BOOLEAN://Boolean          value = String.valueOf(cell.getBooleanCellValue());        break;      case Cell.CELL_TYPE_FORMULA://公式          value = cell.getCellFormula();        break;      case Cell.CELL_TYPE_BLANK://空值      value = "";        break;      case Cell.CELL_TYPE_ERROR://故障      value = "";        break;      default:      value = "";        break;  }return value;}