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

读取复杂的excel表格 : 多块表格读取数据 可以按空格切割吗 跳空格 解析 #405

Open
afish177 opened this issue Dec 4, 2023 · 0 comments

Comments

@afish177
Copy link

afish177 commented Dec 4, 2023

Bug描述
描述Bug产生的现象(A clear and concise description of what the bug is.)

Bug复现
按如下步骤复现(Steps to reproduce the behavior):

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

期望的结果
期望的结果是什么(A clear and concise description of what you expected to happen.)
可以按空格切割吗 跳空格 解析 目前我看解析 是一行行下来的 就算用了stopReadingOnBlankRow还是会从头下来(导致获取的数据行是0 因为顺序下来 空行就停止了) 而不是可以 .rowFilter(row -> row.getRowNum() > startCompRowNum && row.getRowNum() < endCompRowNum).stopReadingOnBlankRow结合 我想 根据某些 来自定义 比如我想 下一块从 不是空行 开始 继续解析 到下一空行结束 以此类推
比如如图 我到第一块空行结束时 这是我的第二块 接下来 我的第二块 是从行3 那么我就想结合.rowFilter(row -> row.getRowNum() > 2 && row.getRowNum() < 9).stopReadingOnBlankRow() 用此会从头解析下来(因为第一块结束后空行) 获取数据行为0 导致无法继续解析第二块
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant