Kotlin/dataframe

WriteExcel sheets support

raudonikis opened this issue · 3 comments

raudonikis commented

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 commented

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

  • ❤️1
raudonikis commented

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

Yes, this works. Thank you so much!