Issue Description
Via jasperreports properties it is possible within JasperReports API and JasperReports Server to export a report in xls format into a pre-existing xls worksheet. This is not available for xlsx, only xls.
Resolution
This feature is based upon properties described in the Xls Advanced Features sample for JasperReports, documented here: http://jasperreports.sourceforge.net/sample.reference/xlsfeatures/
Like the other samples, you can install it into Studio as part of the Samples Project by choosing New -> Project, then browsing to the JasperReport Samples project.
To run it, create a new csv datasource pointing to the dataCsvDataSource.txt file accompanying the sample, then running the report with this new csv datasource.
I tested my own, new values by creating my own, new .xls file, GregBook.xls, which I saved it to the data directory. I was able to achive the feature of adding the report output to the pre-existing GregBook.xls using these properties:
<property name="net.sf.jasperreports.export.xls.workbook.template.keep.sheets" value="true"/>
<property name="net.sf.jasperreports.export.xls.workbook.template" value="data/GregBook.xls"/>
References:
Ref. Case 00055476
Recommended Comments