Hi
It´s possible to export to excel through jasper plugin to an already defined excel template?
I need export to excel a list and in that list I need calculation form discount, unit * price, etc…
Thanks
Hi Carlos,
what I will do if I were you is save the template Excel file to html (put as little content as possible - only one or 2 rows where you will have your whole data -, because Excel html is really verbose!), then open it in a text editor, put Velocity $variables where I want dynamic content (and probably #foreach() loop or even a call to a macro to loop on rows), then I would use it as a template with the VelocityReport plugin, and use Servoy to feed the $variables at runtime using foundset, dataset, calculations, aggregations or even method callbacks.
The report itself would be rendered as HTML, but then you will be able to open it back into Excel, nicely filled with your Servoy-provided data.
-my 2 cents