POI

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.OfficeXmlFileException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;

/**
 * OOXML or OLE2 文档编辑工具
 * @author16  */
public class POIUtil {

    private static Logger log = LoggerFactory.getLogger(POIUtil.class);

    public static String getCellStringValue(Cell cell) {
        if (cell != null) {
            cell.setCellType(CellType.STRING);
            return cell.getStringCellValue();
        }
        return null;
    }

    /**
     * 兼容（OOXML or OLE2）Excel 03和07两种格式 
     * @param regionFile
     * @return
     */
    public static Workbook parseFile(MultipartFile regionFile) {
        Workbook workbook = null;
        try {
            workbook = new HSSFWorkbook(regionFile.getInputStream());
        } catch (OfficeXmlFileException | IOException e) {
            if (e instanceof OfficeXmlFileException) {
                try {
                    workbook = new XSSFWorkbook(regionFile.getInputStream());
                } catch (IOException e1) {
                    log.error("文件解析IO异常", e1);
                }
            } else {
                log.error("文件解析IO异常", e);
            }
        }
        return workbook;
    }
}