Skip to main content

Export to Excel Dialog

  • Updated

Previous Topic  Next Topic

Export to Excel Dialog

The Export to Excel dialog appears when you select File > Export > To Excel. It helps you to export a report to Microsoft Excel format. See the dialog.

The following are details about options in the dialog:

Directory

Specifies the destination directory where the exported Excel file will be placed.

File Name

Specifies the name of the exported Excel file. If you do not type the name, Logi JReport will use the report name as the Excel file name by default.

Select Report Tabs

When exporting a page report, you can specify the report tabs in the page report you want to export to the Excel file. The selected report tabs will be exported into multiple sheets of the Excel file in the list order. If the report has only one report tab, it is selected by default.

Move Up button

Moves the specified report tab one step up.

Move Down button

Moves the specified report tab one step down.

Excel Version

Specifies the Excel version to be used.

  • Excel 97-2003 Workbook (*.xls)
    Exports the file as .xls format.
  • Excel Workbook (*.xlsx)
    Exports the file as .xlsx format.

Format

Specifies the format of the exported Excel file.

  • Report Format
    If checked, Logi JReport will attempt to make the formatting of the report in Excel match the format as designed in the template. Usually this format is recommended if you just want to view the report in Excel.
  • Column Format
    If checked, you can set the Columned property value for the report in the Report Inspector to decide the calculation method used for all components' row/column values in the report when exporting.
  • Data Format
    If checked, only the report data will be exported without format. Available only for Excel 97-2003 Workbook (*.xls).

More/Less Options

Select to show/hide the additional settings for exporting the report to Excel. When Data Format is selected, only Word Wrap and Run Linked Report are available here.

  • Include Shapes in Export
    Specifies whether to include the drawing objects in the exported Excel file, such as line, oval, and box.
  • Print Page Header
    Specifies the page header text for the printed file.
  • Print Page Footer
    Specifies the page footer text for the printed file.
  • Word Wrap
    Specifies the word-wrap settings.
    • 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.
  • Print Gridlines
    Specifies whether to include gridlines when printing the exported Excel file.
  • Run Linked Report
    If the report is linked with other reports, you can check whether or not to generate the linked reports (not including the detail reports) in the exported Excel file.

OK

Applies all changes and closes the dialog.

Cancel

Cancels the changes and exits the dialog.

Help

Displays the help document about this feature.

Previous Topic  Next Topic

Related articles