custom function XLSX receipe

Vaibhav

Please see
https://playground.jsreport.net/studio/workspace/H1qKXWVne/7

I have two concerns here.

I need to convert the Print Date to MM/dd/yyyy format. I wrote a function batchDateTime, but I couldn't call it from the excel receipe report. However the same function is working in phantom PDF. Please let me know How to call these custom functions.
Moreover in the excel row number 9,10,11 are blank. Insertion of data should start from row number 9.

Please let me know what needs to be done to correct it.

Many thanks in advance.

bjrmatos

for point 1: you were not using your batchDateTime helper in the template.
for point 2 : you can control in which position a row should be added using the "r" attribute of a <row>, but in your case it seems that your xlsx file has some metadata in row 9,10 that don't let to insert rows in those places. maybe you can try to open the xlsx file and clean that rows.

updated example with the recomendations: https://playground.jsreport.net/studio/workspace/H1qKXWVne/9

Vaibhav

Thanks I just deleted the rows 9-10-11 from the template and it worked.