XLSX formatting cells

  • If I am using something like


    to add a cell to a new row in an xlsx/handlebars recipe is there any way I can define the cell format other than defaulting to 'General'? Specifically I'm after currency ($#,###.00) and Date (yyyy-mm-dd) formats

    (hopefully just being dumb and missing it in the docs or examples!)

    FWIW this whole spreadsheet it created on demand, we don't have a starting template, not sure if that makes any difference

  • The approach is the same as always.
    Create a formatted cell in excel, save it, unzip it, analyze the content and replicate with the xlsx helpers.

    The only trick, in this case, is that excel expects specific order of xml nodes that you need to change. See the demo here:

Log in to reply

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.