Applying number format to columns

[gyansinha]

I know how to create number formats as in:

    currencyfmt = XLSX.styles_add_numFmt(wb, "\$#,0.00;(\$#,0.00)")
    currencystyle = XLSX.styles_add_cell_xf(
        wb, Dict("applyNumberFormat" => "2", "numFmtId" => "$currencyfmt")
    )

After using something like

XLSX.writetable!(sheet, df)

how would I apply the currencystyle to say column B in the sheet that now contains the dataframe df?

[grahamgill]

Some months have passed, so I hope this still can help. I came across your comment while looking for answers to how to apply styles to cells using XLSX.jl.

The answer I came up with is just to apply XLSX.CellValue(value, style) to each element of a matrix, DataFrame column, etc., in Julia, before writing out to Excel using the methods of XLSX.jl. Maybe not the most elegant or efficient, but it worked for what I needed.

Example here.