XSSFWorkbook读取合并单元格中的数据

直接上代码把

@Service
public class AppInfoUploadServiceImpl implements AppInfoUploadService {
	@Autowired
    private AppInfoMapper appInfoMapper;
	@Autowired
	private CommonMapper commonMapper;
	@Override
	public void uploadAppInfo(MultipartFile file) {
		LogUtil.info("处理app信息数据...");
		String originalFilename = file.getOriginalFilename();
        if (!originalFilename.endsWith("xlsx"))
        {
            throw new BizException(FailedStatusEnum.MUST_EXCEL_FILE, "originalFilename:" + originalFilename);
        }
        XSSFWorkbook xwb = null;
        try
        {
        	List<AppTypePojo> appTypeList = new ArrayList<AppTypePojo>();
            List<AppPojo> appList = new ArrayList<AppPojo>();
            // 读取excel工作簿
            xwb = new XSSFWorkbook(file.getInputStream());
            // 读取excel的词库页
            XSSFSheet sheet = xwb.getSheet("Sheet1");
            Integer sellpointId=null;
            String gradeName = null;
            String subjectName = null;
            String typeName = null;
            String studyProblem = null;
            String scenePic = null;
            String mainAppName = null;
            String mainAppPackageName = null;
            String mainAppIntroduction = null;
            String otherAppName = null;
            String otherAppIntroduction = null;
            String sellpointLatitude = null;
            String addTime=null;
            String lastTime=null;
            AppTypePojo appTypePojo=null;
            AppPojo mainAppPojo=null;
            AppPojo otherAppPojo=null;
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 
            
            for (int i = 1; i <= sheet.getLastRowNum(); i++)
            {
            	List<String> otherAppList = new ArrayList<String>();
                XSSFRow row = sheet.getRow(i);
                if (row != null)
                {
                	Boolean mergedRegion1 = isMergedRegion(sheet, i, 1);
                	if (mergedRegion1) {
                		 gradeName = getMergedRegionValue(sheet, i, 1);
					}else{
						XSSFCell cell = row.getCell(1);
						if (cell!=null) {
							gradeName=cell.getStringCellValue();
						}
					}
                	if (gradeName!=null) {
						if (gradeName.contains("一年级")||gradeName.contains("二年级")) {
							gradeName="一年级#二年级";
						}else if (gradeName.contains("三年级")||gradeName.contains("四年级")) {
							gradeName="三年级#四年级";