XLSX formatting cells
-
If I am using something like
<c> <v>{{budgetoverride}}</v> </c>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:
https://playground.jsreport.net/w/anon/N05jyaXo
