Does anybody know if it’s possible to use ExcelFiles.jl to save multiple sheets to a single xlsx file? I have 3 DataFrames that I would like to save as 3 separate sheets in a xlsx file.
No, not possible at this point. That would be a great extension, though!
You might be able to do it with XLSX.jl directly (which ExcelFiles.jl uses under the hood).
I see. I’m pretty sure it’s possible to do it with XLSX.jl. I’ll have a look.
I didn’t know ExcelFiles.jl uses XLSX.jl under the hood. I was using XLSX.jl before but then switched to ExcelFiles.jl because I like its API better and because it integrates so well with the whole Queryverse story.
David, thanks a lot for your reply and all your hard work on this topic (and many others).