alibaba/easyexcel

总行数获取与实际不符合

Open

#3,836 opened on Jun 16, 2024

View on GitHub
 (3 comments) (0 reactions) (0 assignees)Java (7,599 forks)batch import
help wanted

Repository metrics

Stars
 (33,728 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

建议先去看文档

快速开始 、常见问题

异常代码

   公司监控，不能贴代码

异常提示

大家尽量把问题一次性描述清楚，然后贴上全部异常，这样方便把问题一次性解决掉。 至少大家要符合一个原则就是，能让其他人复现出这个问题，如果无法复现，肯定无法解决。

问题描述

比如excel一共有501行，行行都有内容的，我选中501行后清除内容，然后程序读取总行数还是501行，我打开excel明明就是500行有内容，这怎么办？我确定501行内容我都清除干净，但是如果我选择删除501行，那么程序会正确读到500行；换句话，只要哪行被我输入过值，然后我把单元格里内容清除掉后，程序依旧会认为这个单元格非空，就算行数时候就会把这行算上去，最终导致误差。

Contributor guide

Research direction
Investigate how EasyExcel determines row count after clearing cell contents. Check if the row count is based on last non empty cell or if empty rows are cached. Look into the Excel reading model and whether clearing cells leaves row metadata.
Tech stack
java
Domain
backend
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
Java
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70