SAP BusinessObjects Enterprise InfoView User's Guide

Exporting data from Voyager to Excel

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.



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/