The supplied data appears to be in the Office 2007+ XML

王小新..

于 2023-04-13 19:39:57 发布

阅读量296

点赞数

文章标签： xml java

本文链接：https://blog.csdn.net/weixin_45691427/article/details/130138306

版权

String fileName = file.getOriginalFilename();
            if (!fileName.matches("^.+\\.(?i)(xls)$") && !fileName.matches("^.+\\.(?i)(xlsx)$")) {
                return new Result().error(-1, "导入文件格式不正确!");
            }

Workbook wb = isExcel2003 ? new HSSFWorkbook(is) : new XSSFWorkbook(is);

上面这种，使用以下依赖：

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


        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-scratchpad</artifactId>
            <version>3.10.1</version>
        </dependency>

第二种：

  String fileName = file.getOriginalFilename();
            if (!fileName.matches("^.+\\.(?i)(xls)$") && !fileName.matches("^.+\\.(?i)(xlsx)$")) {
                return new Result().error(-1, "导入文件格式不正确!");
            }
 Workbook wb = WorkbookFactory.create(is);

使用以下依赖：

<dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>4.1.2</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>4.1.2</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>4.1.2</version>
        </dependency>

如果哪里不对的，各位老哥请指教