Writing a dataframe to Excel XLSX

Specific Domains Data
,
5

You can write the data and add a new tab by

using DataFrames
using XLSX
df = DataFrame(Name=["aaaa","bbbb","cccc"], Type = [1,2.0,5.5])
XLSX.openxlsx("MyXLfile.xlsx",mode="rw") do xf
     XLSX.addsheet!(xf,"Required_tab")
     sheet = xf["Required_tab"]
     for r in 1:size(df,1), c in 1:size(df,2)
          sheet[XLSX.CellRef(r , c )] = df[r,c]
     end
end
3 Likes