Java常用代码实现——解析excel

pom依赖：

    org.apache.poi
    poi
    3.16



    org.apache.poi
    poi-ooxml
    3.16

解析excel:

public List addBatchTopicDetail(MultipartFile multipartFile) throws Exception {
    List topicDetailList = new ArrayList<>();
    Row row = null;
    NewsFeedTopicDetailInfo newsFeedTopicDetailInfo = null;
    int i = 1;
    // 获取excel
    Workbook wb = WorkbookFactory.create(multipartFile.getInputStream());
    // 返回表中实际的行数
    Sheet sheet = wb.getSheetAt(0);
    // 获取总行数
    int rownum = sheet.getPhysicalNumberOfRows();
    
    // 读取每一行的值，解析成对象
    for (i = 1; i < rownum; i++) {
        newsFeedTopicDetailInfo = new NewsFeedTopicDetailInfo();
        row = sheet.getRow(i);
        newsFeedTopicDetailInfo.setCommentId((row.getCell(0).getStringCellValue()));
        newsFeedTopicDetailInfo.setOrderType((int) (row.getCell(1).getNumericCellValue()));
        topicDetailList.add(newsFeedTopicDetailInfo);
    }

    return topicDetailList;
}


public Boolean addBatchDetail(@RequestParam("file") MultipartFile multipartFile) {}

参考：https://www.jianshu.com/p/b36c9230089f