On the application toolbar, click Export.
You can export data from Voyager queries to Microsoft Excel, to allow Excel users to share your data. The data can either be viewed immediately in Excel, or saved to an .xls file that can be opened with Excel or third-party applications. To view your data immediately in Excel, you must have Excel already installed on your machine.
Data is exported in the orientation displayed in the crosstab. If the query has only a chart component associated with it, data from that query is exported but the chart visualization is not. Rows in the exported file correspond to rows in the crosstab, or data series in the chart. Columns in the exported file correspond to columns in the crosstab, or categories in the chart.
Sorts, filters, and ranks are preserved in the exported data. Calculated data is exported, but the calculation formulas are not preserved.
To export data from Voyager to Excel
1. Go to the page that contains the component whose data you want to export, and select the component.
2. On the application toolbar, click Export.
3. In
the dialog box, specify whether you want to view the file or save the file
to disk, and then click OK.
If you choose to save the file to disk, specify the name and location of the
file that you want to export your data to.
If you choose to view the file, it opens immediately in Excel.
The
Export button is disabled until the current page contains a valid query.