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

WriteExcel sheets support #578

Closed
raudonikis opened this issue Feb 1, 2024 · 3 comments
Closed

WriteExcel sheets support #578

raudonikis opened this issue Feb 1, 2024 · 3 comments
Labels
question Further information is requested
Milestone

Comments

@raudonikis
Copy link

raudonikis commented Feb 1, 2024

Hi, looks like there is an issue with the sheet functionality for excel files, unless I am missing something. Writing to the same excel file with different sheet names (I would expect that new sheets would be created) simply overrides the previous sheet. Is there any way to add sheets to an already existing excel file? Or at least add columns to an already existing file?
This is what I've tried:

dataFrame.writeExcel(filePath, sheetName = "results")
anotherDataFrame.writeExcel(filePath, sheetName = "more results")

I am using version 0.12.1.

@koperagen
Copy link
Collaborator

koperagen commented Feb 1, 2024

New parameter on 0.13.0-dev-2801 should do the trick.

dataFrame.writeExcel(filePath, sheetName = "results")
anotherDataFrame.writeExcel(filePath, sheetName = "more results", keepFile = true)

I would expect that new sheets would be created

Interesting point about default behavior. Maybe it should be like this, indeed

@raudonikis
Copy link
Author

New parameter on 0.13.0-dev-2801 should do the trick.

Yes, this works. Thank you so much!

@koperagen koperagen added the question Further information is requested label Feb 1, 2024
@zaleslaw zaleslaw modified the milestones: 0.14.0, 0.13.+ Apr 23, 2024
@zaleslaw
Copy link
Collaborator

It was fixed

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

No branches or pull requests

3 participants