On the
application toolbar, click the arrow beside the Export button, and
select CSV.
You can export data from Voyager queries to comma-separated-value format, to allow users of other applications to share your data. The comma-separated values can either be viewed immediately in an application such as Excel, or saved to a .csv file.
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 a .csv file
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 the arrow beside the Export button, and
select CSV.
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 your .csv file
viewer, which is Microsoft Excel by default.
The
Export button is disabled until the current page contains a valid query.