@Override public Result importData(MultipartFile file) { long l1 = System.currentTimeMillis(); if (!file.isEmpty()) { if (!file.getOriginalFilename().endsWith("xlsx") && !file.getOriginalFilename().endsWith("xls")) { return Result.build().msg("文件格式错误,请检查文件格式!"); } InputStream fileInputStream = null; try { fileInputStream = file.getInputStream(); Workbook workbook = null; if (file.getOriginalFilename().endsWith("xls")) { workbook = new HSSFWorkbook(fileInputStream); } else if (file.getOriginalFilename().endsWith("xlsx")) { workbook = new XSSFWorkbook(fileInputStream); } Sheet sheet = workbook.getSheetAt(0); int rows = sheet.getLastRowNum(); if (rows > 10) {
Row xrow = sheet.getRow(6);
Cell cell = xrow.getCell(10); if (DateUtil.isCellDateFormatted(cell) && new BigDecimal(dateDouble).compareTo(new BigDecimal(cell.getNumericCellValue()))==0 && eventType.equals(xrow.getCell(11))) {//沿用上一行灾害事件 } else {//新灾害事件 hdEvent = new HouseDisasterEvent(); eventType = getValue(xrow.getCell(11)); if (DateUtil.isCellDateFormatted(cell)) { dateDouble = cell.getNumericCellValue(); Date eventDate = DateUtil.getJavaDate(dateDouble); if (eventDate != null) { hdEvent.setDisasterDate(eventDate); } } hdEvent.setDisasterType(getTypeInteger((HashMap<Integer, String>) eventTypeMap, eventType)); if (shengName != null && !"".equals(shengName)) { eventName = shengName + "_" + new SimpleDateFormat("yyyy-MM-dd").format(hdEvent.getDisasterDate()) + "_" + eventType; } hdEvent.setDisasterEventName(eventName); hdEvent.setAreaName(shengName + xianName); houseDamageLedgerMapper.insertEvent(hdEvent); }