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.

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

ignoreEmptyRow(true), 忽略末尾空白行无效 #4036

Open
fengyts opened this issue Oct 27, 2024 · 1 comment
Open

ignoreEmptyRow(true), 忽略末尾空白行无效 #4036

fengyts opened this issue Oct 27, 2024 · 1 comment
Assignees
Labels
help wanted Extra attention is needed

Comments

@fengyts
Copy link

fengyts commented Oct 27, 2024

建议先去看文档

快速开始常见问题

触发场景描述

忽略末尾空白行无效。
附件信息:
test.xlsx

触发Bug的代码

@Test
    public void testIgnoreEmptyRow(){
        File file = new File("E:\\test\\test.xlsx");

        List<Object> objects = EasyExcel.read(file).ignoreEmptyRow(true).doReadAllSync();
        System.out.println();
    }

提示的异常或者没有达到的效果

没有报错,但是末尾行没有忽略空白行。
版本信息:EasyExcel版本:3.0.5,poi: 4.1.2, poi-ooxml: 4.1.2
image

@fengyts fengyts added the bug Something isn't working label Oct 27, 2024
@psxjoy psxjoy added help wanted Extra attention is needed and removed bug Something isn't working labels Oct 28, 2024
@psxjoy
Copy link
Collaborator

psxjoy commented Oct 28, 2024

It's not a bug.
Even if you see all sheets are empty, when you open this file using unzip, you will find these(you think are empty) cells have some style config, which can be considered real data without the real info(such as number or string) but truly a useful cell.

@psxjoy psxjoy self-assigned this Oct 28, 2024
@alibaba alibaba deleted a comment Oct 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

3 participants