When exporting to an Excel file, if you have several reports in your document, you can decide to export all of them or explicitly select the ones to export. Each report is saved as a spreadsheet in the Excel file. You can export either:

• Reports' data, by selecting the Reports radio button, and selecting the reports you want to export.
• Documents' raw data by selecting the Data radio button, and selecting the queries you want to export.

You can select between two options:

• Check Prioritize the formatting of the document to keep the formatting in the .xlsx file.
• Check Prioritize easy data processing in Excel to avoid merging multiple cells into Excel cells as much as possible and benefit from the data processing features of Excel.

You can also fine-tune the DPI for images using the Images DPI drop down list.

Note: The maximum number of columns supported during the export is limited. By default, the limit is set to 16383 for .xlsx sheets. The application automatically truncates generated sheets to fit within these limits. Other columns aren't exported.

When exporting to a .pdf file, you can decide whether you want to export all reports if you have several reports in your document, or only the report you are currently viewing. If you decide to export only one report, then it's possible to select whether you want to export:

• All pages
• The current page, only if you have selected to export the report you are currently viewing.
• Specific pages, for example pages 10 to 15 only

You can also fine-tune the DPI for images using the Images DPI drop down under the Options section.

Check Display bookmarks to display the bookmarks tab by default when opening the file to make the navigation through the document easier.

When you export a text file:

• In page mode, report elements are exported page by page.
• The exported file in page mode can be different from the result in draft mode.
• The separator used is a tab space.
• Charts and images aren't exported.
• Export size limit for text file is defined in the Central Management Console. The default value is 5 MB. An error message appears if the size limit is exceeded.
• If several reports are selected, they are appended one after another in the same text file.

You can export either:

• Reports' data, by selecting the Reports radio button, and selecting the reports you want to export.
• Documents' raw data by selecting the Data radio button, and selecting the queries you want to export.

You can also configure the text qualifier, column delimiter and charset. In the column delimiter drop down, you can also directly type in a custom character you want to use, such as the pipe (|) for instance.

CSV files are exported as ZIP files.

Note: To prevent malicious command injections from being triggered when you open the CSV file in Microsoft Excel, Web Intelligence adds a space before the following characters during the export process:

• = (Equal)
• + (Plus)
• - (Minus)
• @ (At)

The additional space prevents values with these characters from being executed as commands, which could cause a security issue on your system.

HTML files are exported as ZIP files.

If several reports are selected, they are appended one after another in the same HTML file.