Writing dataframes or arrays from Julia to excel file

[Nathan_Boyer]

I answered a similar question here:

Create excel file using data from two dataframes

The "rw" mode is a little dangerous, especially if your Excel document contains formulas (reference). Also, the do block form is more robust; it will always automatically close the file. This is how I would do it. using DataFrames, XLSX df1 = DataFrame( A = [1, 2, 3, 4, 1], B= ["M", "F", "F", "M", "O"], ) df2 = DataFrame( AA = ["aa", "bb"], AB = [10.1, 10.2], ) filepath = "./xlsxtest.xlsx" startrow = nrow(df1) + 3 startcolumn = 1 XLSX.openxlsx(filepath, mode="w") do file s…

The anchor_cell keyword argument must be passed a XLSX.CellRef. Rocco showed how to use a cell name for your anchor cell, but you can also use row and column indices as I did in the link.