基于POI的Excel文件解析

1、依赖包

<dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi</artifactId>
   <version>3.15</version>
</dependency>

 <dependency>
   <groupId>org.apache.poi</groupId>
   <artifactId>poi-ooxml</artifactId>
   <version>3.15</version>
</dependency>

2、工具类原代码

package com.sinotrans.iwl.fdr.acc.util;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;

public class PoiExcelUtil {
 private static final String EXCEL_XLS = "xls"; 
    private static final String EXCEL_XLSX = "xlsx"; 
 
    /**
     * 判断Excel的版本,获取Workbook
     * @param in
     * @param filename
     * @return
     * @throws IOException
     */ 
    public static Workbook getWorkbok(InputStream in,MultipartFile file) throws IOException{ 
        Workbook wb = null; 
        if(file.getOriginalFilename().endsWith(EXCEL_XLS)){  //Excel 2003 
            wb