Skip to content

dump several arrays after each other on a sheet without specifying position #826

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
Open
gdementen opened this issue Nov 26, 2019 · 2 comments
Open

dump several arrays after each other on a sheet without specifying position #826

gdementen opened this issue Nov 26, 2019 · 2 comments
Labels
component: excel enhancement priority: high
Milestone
0.35

Comments

@gdementen
Copy link
Contributor

gdementen commented Nov 26, 2019 •
edited
Loading

currently, when you want to dump several tables below each other you have to provide precise positions. It would be nice to have a way to dump arrays below each other.

see demo/table_generator
@gdementen gdementen mentioned this issue Nov 10, 2020
Open
@gdementen
Copy link
Contributor Author

we have more and more users who either asked for this explicitly or would benefit from this

@gdementen
Copy link
Contributor Author

gdementen commented Feb 4, 2021 •
edited
Loading

FWIW, I found two workarounds:

sheet[sheet.shape[0], 0] = something_to_write
# OR
sheet[sheet.used_range.rows.count, 0] = something_to_write

One can of course add a +1 in there to leave blank rows between dumps

@gdementen gdementen mentioned this issue Sep 1, 2021
Open
@gdementen gdementen mentioned this issue Jul 6, 2022
Open
@gdementen gdementen added this to the 0.35 milestone Mar 15, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
component: excel enhancement priority: high
Projects
None yet
Milestone
0.35
Development

No branches or pull requests
1 participant
@gdementen