Skip to content

Comments

Added support for sheet.getLastRowNum()#56

Merged
monitorjbl merged 2 commits intomonitorjbl:masterfrom
edgraaff:master
Sep 26, 2016
Merged

Added support for sheet.getLastRowNum()#56
monitorjbl merged 2 commits intomonitorjbl:masterfrom
edgraaff:master

Conversation

@edgraaff
Copy link

@edgraaff edgraaff commented Sep 2, 2016

Hello,

Great work on this project, it really simplifies reading a workbook which used to be pretty low-level.

This pull request is regarding adding support for getLastRowNum. I specifically aimed on this method as it is used to report the total number of rows back to the user. This can in turn be used to show a progress bar and estimate remaining time.

It basically picks the ref attribute from the dimension element at the top of a sheet. This is formatted as 'A1' or A1:A3000'. Either way, we're only interested in the last number (and subtract 1 so that we get a 0-based row index).

The implementation of StreamingSheetReader.handleEvent captures this 'dimension' element.
A test case was added that tests a sheet with rows, as well as a sheet containing only one row.

Hope you like it :)

(edit: re-opened this pull request as it appeared to break a test ... what was I thinking? probably time for weekend!)

@monitorjbl
Copy link
Owner

Sorry for the delay, I've been traveling a lot this month and haven't had time to review PRs in GitHub. Looks good to me!

@monitorjbl monitorjbl merged commit e91413c into monitorjbl:master Sep 26, 2016
@edgraaff
Copy link
Author

No prob, glad to hear that the PR is accepted :)

Am 26.09.2016 um 17:46 schrieb Taylor Jones [email protected]:

Sorry for the delay, I've been traveling a lot this month and haven't had time to review PRs in GitHub. Looks good to me!


You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub #56 (comment), or mute the thread https://github.com/notifications/unsubscribe-auth/ARD3M2ccNu_FpdVwPQVCxEkw4bHZKV5Sks5qt-i5gaJpZM4JzeYz.

@ms1111 ms1111 mentioned this pull request Jan 11, 2017
rimuln pushed a commit to rimuln/excel-streaming-reader that referenced this pull request Nov 15, 2021
Bumps [slf4j-api](https://github.com/qos-ch/slf4j) from 1.7.31 to 1.7.32.
- [Release notes](https://github.com/qos-ch/slf4j/releases)
- [Commits](https://github.com/qos-ch/slf4j/commits)

---
updated-dependencies:
- dependency-name: org.slf4j:slf4j-api
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
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

Successfully merging this pull request may close these issues.

2 participants