Write to XLSX file while maintaining formatting

General Usage
, ,
1

Hi,

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[1]
        XLSX.writetable!(sheet, collect(DataFrames.eachcol(df)), DataFrames.names(df))
    end
2

Linking related thread with an alternative solution.