To Excel
To export the results of a report to an Excel file, follow the steps below:
- In JReport Designer, open the web report or the report tab in a page report that you want to export.
- Click File > Export To > Excel to display the Export to Excel dialog. See the dialog.
- Click the Browse button to specify the destination directory where the exported Excel file will be placed, or type the destination directory into the Directory text field directly (make sure that the folder you specify here does exist).
- Specify the name of the exported Excel file in the File Name text field. If you do not type the name, JReport will use the report name as the Excel file name by default.
- From the Excel Version drop-down list, select the version for the exported Excel file.
- Specify the format of the exported Excel file.
- To make the format of the result file match the format as designed in the template, check Report Format, and then specify the available settings according to your requirements.
- To export the report results to a general Excel file, check Column Format, in which case, you can set the Columned property value for the report tab in the Report Inspector to decide the calculation method used for all components' row/column values in the report when exporting (due to the particularity of mailing label report, do not set the Columned property to true when you want to export it in this format).
- To export only the report data without format, check Data Format. This option is only available for the Excel version Excel 97-2003 Workbook (*.xls).
- Check Run Linked Report if you want to include the linked reports in the exported Excel result.
- When done, click OK to start exporting.
See also Export to Excel dialog for detailed explanation about options in this dialog.
Notes:
- Multiple colors and languages in a report can be exported to an Excel file, but multiple pie charts and the arc drawing object cannot be. For example, Excel only supports 56 kinds of colors, if there are more than 56 kinds of colors in a report, when you export the report to Excel, some colors will be merged.
- When exporting a report to Excel,
- Paragraphs and texts in the report will be exported as objects.
- If the data type of the field on the category axis of a chart is Date, DateTime or Time whose format confirms to the date format of the Excel, the axis will be exported as a date axis, otherwise, it will not be exported as a date axis.
- Gauge and surface chart in the report will be exported as bar chart while stock chart will be exported as image.
- The minor tick marks on a chart will not be exported.
- If the field on the category axis of a chart is of Number type and you use a constant interval to customize the tick marks on the axis, the settings will not take effect.
- If the report contains a drop-down list, only the value selected in the list will be exported.
- If you set an object's Export to Excel property to false, the object and other objects contained in it will not be exported.
- When Data Format is selected in the Export to Excel dialog, formulas, barcodes, images, HyperLink property, charts and all drawing objects will not be supported, therefore, we recommend not using this format when exporting report results to Excel.
The following are some specific topics related with exporting the report results to Excel:
Related topics: