Generate csv from excel recipe

[benben-user]

I have an excel recipe, 1 tab with simple table.
I need to return the report as CSV format,
What is the simplest way to do it ? (don't want to replace recipe to text or html)
afterRender ?
maybe use sheetjs like in this example link ?

var csv = XLSX.utils.sheet_to_csv(worksheet, opts);

@jan_blaha @bjrmatos

TY

[bjrmatos]

hi @benben-user yes the afterRender is the way to go, here you have a simple example that gives you an idea about how to shape things for your code to work and produce csv

[bjrmatos]

in the example i use the html-to-xlsx recipe just to quickly generate an xlsx file, but of course this should work with the xlsx recipe too, all that is needed is a recipe that produces xlsx