软件excel解析

whycxzp

2022-09-07 7dd8a7a631875d68d6409f5086041d474d9226a8

 src/main/java/com/whyc/service/SoftwareService.java

@@ -5,7 +5,6 @@
import com.whyc.dto.Response;
import com.whyc.mapper.SoftwareMapper;
import com.whyc.pojo.Software;
import com.whyc.util.DateUtil;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
@@ -54,8 +53,7 @@
        common.setBasedVersion(sheet.getRow(4).getCell(4).getStringCellValue());

        common.setOwner(sheet.getRow(5).getCell(2).getStringCellValue());
        String filingDateStr = sheet.getRow(5).getCell(4).getStringCellValue();
        Date filingDate = DateUtil.YYYY_MM_DD.parse(filingDateStr);
        Date filingDate = sheet.getRow(5).getCell(4).getDateCellValue();
        common.setFilingDate(filingDate);
        //最后一行,取发布说明
        common.setReleaseNotes(sheet.getRow(lastRowNum).getCell(2).getStringCellValue());