Oracle® Business Intelligence Discoverer Plus User's Guide
10g Release 2 (10.1.2.0.0) Part No. B13915-01 |
|
![]() Previous |
![]() Next |
You can export worksheet data from Discoverer to Microsoft Excel. You can also export formats and formulas to Microsoft Excel. When you export to Excel, your worksheet fonts, colors, and styles are preserved in Excel.
Note: For more information about exporting worksheet data to Microsoft Excel Web Query format, see "About exporting worksheets to Microsoft Excel".
The table below shows how different versions of Microsoft Excel impose limits on the maximum number of Discoverer rows allowed in an Excel sheet.
Microsoft Excel version | Maximum number of Discoverer rows per Excel sheet | How Microsoft Excel handles additional rows |
---|---|---|
Excel 97 | 65,536 | Any additional rows are placed on additional Excel sheets. |
Excel 2000 | 65,536 | Any additional rows are placed on additional Excel sheets. |
Notes
When you export a worksheet and a graph to Excel format, the worksheet data is displayed in the spreadsheet. The graph file (a PNG format file by default) is placed in the default drive location, and can be inserted manually into the spreadsheet using Excel's Insert | Picture | From File option.
Contact the Discoverer manager to find out whether Discoverer is configured to export to Microsoft Excel 97.
When export worksheets to Microsoft Excel, you must export to a version of Microsoft Excel in the same local language as Discoverer Plus Relational.
If you are exporting from Discoverer Plus Relational to Microsoft Excel using Internet Explorer v6.0, a separate browser window might not launch as expected. This problem is due to a change in behavior in Internet Explorer v6.0.
Follow these instructions to work around the problem by specifying the Discoverer middle tier as a trusted site in Internet Explorer:
Select Tools | Internet Options from the Internet Explorer menu bar to display the Internet Options dialog.
Display the Security tab.
Select the Trusted Sites icon and click the Sites button to display the Trusted sites dialog.
Enter the URL of the Discoverer middle tier in the format: http://<host.domain>:<port>, where:
<host.domain> is the server name and domain on which the Oracle HTTP Server is installed
<port> is the port number (typically 7777 or 7778) on which Discoverer is installed
Note: If you do not know the host.domain or port details, contact the Discoverer manager.