I’m trying to write data to a .xlsx file that has already been formatted (cell size, colors, etc.). Is there anyway to write data to a .xlsx file while maintaining the existing formatting? I’m currently using the XLSX.jl function writetable!() shown in the code below. However, this does not maintain the formatting of the original file.
XLSX.openxlsx(filename, mode="rw") do xf sheet = xf XLSX.writetable!(sheet, collect(DataFrames.eachcol(df)), DataFrames.names(df)) end