Improving the performance of exporting to Excel

Normally, when a report is being exported to an Excel file, the coordinates of the report objects are calculated by JReport Engine, and can require a great deal of processing time. However, you can arrange the coordinates of the report objects manually at design time, so that the extra position calculating time can be saved. To do this:

1. Select the node that represents the report in the Report Inspector.
2. In the Properties panel, set the Columned property for the report to true.
3. Set the values of Column Index and Row Index for each object to define the position of the object in the exported Excel file.
4. Click File > Export To > Excel.
5. In the Export to Excel dialog, select Column Format.
6. Set the other options as required.
7. Click OK to start exporting.