Exporting to Excel
This topic introduces how to export the results of a report to an Excel file.
- Open the report that you want to export.
- Select File > Export > To Excel. The Export to Excel dialog appears.
- Select the Browse button to specify the destination directory where the exported Excel file will be placed and the name of the file. You can also input the location and file name manually in the Directory and File Name text boxes (make sure that the folder you specify does exist, otherwise an error message will be produced).
- If you are exporting a page report, in the Select Report Tabs box, select the report tabs in the page report you want to export. The selected report tabs will be exported into multiple sheets of the Excel file in the list order. You can select or to change the order of the report tabs.
- From the Excel Version drop-down list, select the version for the exported Excel file.
- Select the format of the exported Excel file from the Format drop-down list.
- To let Logi JReport choose which format is the most appropriate, select Auto Format, then Logi JReport will judge whether to use Report Format or Column Format according to the objects in the report. If the report contains crosstabs or tables, Column Format will be used; otherwise it is Report Format. This option is selected by default. If you do not know which format is better, it is suggested that you select this option.
- 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 result 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). When Data Format is selected, formulas, barcodes, images, hyperlink property, charts and all drawing objects such as line, oval, and box will not be supported, therefore this format is not recommended when exporting report result to Excel.
- Select More Options to customize other properties for the exported Excel file if needed.
- If you have selected the format other than Data Format, check Include Shapes in Export if you want to include the drawing objects in the exported Excel file, and specify the page header and footer text to be displayed and whether to include gridlines when printing the exported Excel file.
- From the Word Wrap drop-down list, specify the word wrap setting for the report components in the Excel result.
- All Keep Existing
Keeps all settings of each component's Word Wrap property as specified in the report.
- All Disabled
Disables the Word Wrap property for all components, that is the Word Wrap property is made false for all components.
- All Enabled
Enables the Word Wrap property for all components, that is the Word Wrap property will be made true for all components.
- All Keep Existing
- Check Run Linked Report if you want to include the reports that is linked with the report (not including the detail reports) in the Excel result. If you are only interested in the primary report, leave this option unchecked. Generating linked reports at the same time, especially when the linked reports contain a large amount of data, will cause performance issue.
- Select OK to start exporting.
You should pay attention to the following when using the Export to Excel feature:
- 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.
- 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 the Drop-down List object, 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.
Tip: Logi JReport provides several properties related with exporting page report tabs to Excel, which can help you enhance the report appearance in the exported Excel file, manage data in the Excel worksheet, improve the exporting performance and so on. These properties include: Merge to Next Panel, Repeat in Detail Panel, Remove Blank Row, On New Sheet, Rows per Sheet, Column Index, Row Index, Bottom Attach Column, Bottom Attach Row, Top Attach Column, Top Attach Row, Column Number, Row Number, Column Width List, Excel Buffer Size. You can set them according to your requirements appropriately.