java判断是excel2003还是2007以上

public static Workbook create(InputStream in) throws     
    IOException,InvalidFormatException {
        if (!in.markSupported()) {
            in = new PushbackInputStream(in, 8);
        }
        if (POIFSFileSystem.hasPOIFSHeader(in)) {
            return new HSSFWorkbook(in);
        }
        if (POIXMLDocument.hasOOXMLHeader(in)) {
            return new XSSFWorkbook(OPCPackage.open(in));
        }
        throw new IllegalArgumentException("你的excel版本目前poi解析不了");

    }
读写xls和xlsx格式时,HSSFWorkbook针对xls,XSSFWorkbook针对xlsx

 

posted @ 2019-09-09 17:10  君子笑而不语  阅读(1779)  评论(0编辑  收藏  举报