In the package XLSX.jl, there is a useful capability of writing multiple excel sheets into a new file from several dataframes. From the documentation:
XLSX.writetable("report.xlsx", REPORT_A=( collect(DataFrames.eachcol(df1)), DataFrames.names(df1) ), REPORT_B=( collect(DataFrames.eachcol(df2)), DataFrames.names(df2) ))
If I have two vectors, one of sheet titles (i.e., report_vec = [REPORT_A, REPORT_B, …]) , the other vector of DataFrames (i.e., df_vec = [df1, df2, …]), each of length about 20, is it possible to write them all into the same excel file?
It feels as though I’m missing something very simple that involves splatting, but I just can’t get it. Any help very much appreciated.