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

How to read excel in cursor mode, that is, reduce memory reading in batches? #646

Closed
yzdzh opened this issue Jun 3, 2020 · 3 comments
Closed

How to read excel in cursor mode, that is, reduce memory reading in batches? #646

yzdzh opened this issue Jun 3, 2020 · 3 comments
Labels
duplicate This issue or pull request already exists

Comments

@yzdzh
Copy link

yzdzh commented Jun 3, 2020

How to read excel in cursor mode, that is, reduce memory reading in batches?
@xuri
Copy link
Member

xuri commented Jun 3, 2020

You can get all the data in the worksheet as streaming by Rows, read the data row by row using Next, also ref: #515.

@xuri xuri added the duplicate This issue or pull request already exists label Jun 3, 2020
@yzdzh
Copy link
Author

yzdzh commented Jun 4, 2020

You can get all the data in the worksheet as streaming by Rows, read the data row by row using Next, also ref: #515.

After reading the source code, the bottom layer of openFile method is to call openreader method to read data. How to write if you want to read the code line by line?

@xuri
Copy link
Member

xuri commented Oct 3, 2020

We can be R/W XML only after unzipping OOXML format files, I'll close this PR, also reference #489 still discuss stream R/W.

@xuri xuri closed this as completed Oct 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
duplicate This issue or pull request already exists
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@xuri @yzdzh