Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

解析excel 用推荐的ExcelReader不传ExcelTypeEnum的方法 就无法识别他的类型 #115

Closed
GoldRong opened this issue Nov 7, 2018 · 7 comments
Closed

解析excel 用推荐的ExcelReader不传ExcelTypeEnum的方法 就无法识别他的类型 #115

GoldRong opened this issue Nov 7, 2018 · 7 comments

Comments

@GoldRong
Copy link

GoldRong commented Nov 7, 2018 •
edited

` public static void noModelMultipleSheet() {
InputStream inputStream=null;
try {
inputStream = new FileInputStream("C:\Users\xurong\Desktop\abc.xlsx");

        ExcelReader reader = new ExcelReader(inputStream,null,
                new AnalysisEventListener<List<String>>() {
                    @Override
                    public void invoke(List<String> object, AnalysisContext context) {
                        System.out.println(
                                "当前sheet:" + context.getCurrentSheet().getSheetNo() + " 当前行：" + context.getCurrentRowNum()
                                        + " data:" + object);
                    }
                    @Override
                    public void doAfterAllAnalysed(AnalysisContext context) {

                    }
                });

        reader.read();
    } catch (Exception e) {
        e.printStackTrace();

    } finally {
        try {
            inputStream.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}`

com.alibaba.excel.exception.ExcelAnalysisException: Analyse excel occur file error fileType XLSX
at com.alibaba.excel.analysis.ExcelAnalyserImpl.getSaxAnalyser(ExcelAnalyserImpl.java:34)
at com.alibaba.excel.analysis.ExcelAnalyserImpl.analysis(ExcelAnalyserImpl.java:53)
at com.alibaba.excel.ExcelReader.read(ExcelReader.java:92)
at com.example.demo.DockerTestController.noModelMultipleSheet(DockerTestController.java:47)
at com.example.demo.DockerTestController.main(DockerTestController.java:26)
Caused by: org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open XML) file
at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:286)
at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:756)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:327)
at com.alibaba.excel.analysis.v07.XlsxSaxAnalyser.(XlsxSaxAnalyser.java:44)
at com.alibaba.excel.analysis.ExcelAnalyserImpl.getSaxAnalyser(ExcelAnalyserImpl.java:31)
... 4 more
@GoldRong GoldRong changed the title 解析excel 不传ExcelTypeEnum 就无法识别他的类型 解析excel 用推荐的ExcelReader不传ExcelTypeEnum的方法 就无法识别他的类型 Nov 7, 2018
@rends
Copy link

rends commented Nov 7, 2018

我也遇到同样的问题

@hello2z
Copy link

hello2z commented Nov 7, 2018

使用1.1.1不传ExcelTypeEnum会报错，内容如下：

public static void main(String[] args) throws Exception{
        InputStream inputStream = getInputStream("d:/test.xlsx");
        try {
            // 解析每行结果在listener中处理
            MyExcelListener listener = new MyExcelListener();
            ExcelReader excelReader = new ExcelReader(inputStream,null, listener);
            excelReader.read();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                inputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }

com.alibaba.excel.exception.ExcelAnalysisException: Analyse excel occur file error fileType XLSX
at com.alibaba.excel.analysis.ExcelAnalyserImpl.getSaxAnalyser(ExcelAnalyserImpl.java:34)
at com.alibaba.excel.analysis.ExcelAnalyserImpl.analysis(ExcelAnalyserImpl.java:53)
at com.alibaba.excel.ExcelReader.read(ExcelReader.java:92)
at com.lib.easyexcel.service.ReadExcel.main(ReadExcel.java:19)
Caused by: org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open XML) file
at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:286)
at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:756)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:327)
at com.alibaba.excel.analysis.v07.XlsxSaxAnalyser.(XlsxSaxAnalyser.java:44)
at com.alibaba.excel.analysis.ExcelAnalyserImpl.getSaxAnalyser(ExcelAnalyserImpl.java:31)
... 3 more

@Maijh97
Copy link

Maijh97 commented Nov 9, 2018

请问，问题解决了吗？

@leTeng
Copy link

leTeng commented Nov 9, 2018

我使用POI4.0.0还会报错。下面有一个回答提供了一个解决方案:

public void read(String filePath,ExcelTypeEnum type,AnalysisEventListener<T> listener,
                     Class<T> model,boolean isTrim) throws IOException{
        File excelFile = new File(filePath);
        if(!excelFile.exists()){
            throw new NotFoundFileException("This file was not found, and the target path is:[ "+
                    filePath +" ]");
        }
        //使用BufferedInputStream装饰一下FileInputStream
        read(new BufferedInputStream(new FileInputStream(filePath)),type,listener,model,isTrim);
    }

vivisidea added a commit to vivisidea/easyexcel that referenced this issue Nov 10, 2018
@vivisidea
bugfix: FileMagic.valueOf(in) 操作会消耗原始inputStream(markSupported=false的…
ee1dc11 
…情况下)，导致后续真正读取文件时报错

相关issue
alibaba#115
@vivisidea vivisidea mentioned this issue Nov 10, 2018
Closed
@Chat2DB-Pro
Copy link
Contributor

Chat2DB-Pro commented Nov 13, 2018 •
edited

1.1.2-beat2处理了这个问题，但是如果是03版excel需要在输入流左一层new BufferedInputStream(new FileInputStream("/xxxx/xxx/77.xls")确保markSupported 返回true

@whyoyyx whyoyyx mentioned this issue Aug 25, 2019
Closed
@lyqiai
Copy link

lyqiai commented Jun 24, 2021

2.2.10同样的问题

@xiuhulxc
Copy link

属实

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
8 participants
@GoldRong @hello2z @lyqiai @Chat2DB-Pro @rends @Maijh97 @leTeng @xiuhulxc