| | |
|---|
| | | boolean hasPeriodSheet = false; |
|---|
| | | for (int i = 0; i < wb.getNumberOfSheets(); i++) { |
|---|
| | | String sn = wb.getSheetAt(i).getSheetName(); |
|---|
| | | if (sn != null && (sn.contains("当月") || sn.contains("累计"))) { hasPeriodSheet = true; break; } |
|---|
| | | if (sn != null && (sn.contains("当月") || sn.contains("月份") || sn.contains("累计"))) { hasPeriodSheet = true; break; } |
|---|
| | | } |
|---|
| | | if (!hasPeriodSheet) { |
|---|
| | | throw new RuntimeException("所选数据类型【规上规下拆分】与文件内容不符：未找到含 当月/累计 的 sheet，请确认是否选错了数据类型"); |
|---|
| | |
|---|
| | | Sheet sheet = wb.getSheetAt(i); |
|---|
| | | String sheetName = sheet.getSheetName(); |
|---|
| | | String periodType = null; |
|---|
| | | if (sheetName.contains("当月")) periodType = "MONTH"; |
|---|
| | | if (sheetName.contains("当月") || sheetName.contains("月份")) periodType = "MONTH"; |
|---|
| | | else if (sheetName.contains("累计")) periodType = "CUMULATIVE"; |
|---|
| | | if (periodType == null) continue; |
|---|
| | | |
|---|
