About exporting Discoverer data to other applications

You can share your worksheets and graphs with other people by exporting the worksheets to popular application formats (e.g. Oracle Reports, Microsoft Excel). For example, you might want to:

e-mail a Discoverer worksheet in HTML format to your manager
use the power of Oracle Reports to customize a Discoverer worksheet

You can use Discoverer's Export Wizard to export worksheets and graphs in other formats (for more information, see "How to export Discoverer data"). You can also use buttons on the toolbar to export Discoverer data to Microsoft Excel and HTML formats.

When you export a worksheet, you export the data in the worksheet. Depending on the export format you choose, the exported worksheet might also contain its formatting and layout information. In some application formats, the exported worksheet might also contain Discoverer items. For example, if you export to Oracle Reports you export Discoverer calculations and totals. In other words, you can view the exported data in another application, but you cannot apply all Discoverer features to the data in that application.

In Discoverer, you export data for items currently displayed on the worksheet. If you want to export data that is not currently displayed, make sure that you display the items on the worksheet before you start. If you do not want to export data displayed on the worksheet, make sure that you remove the items from the worksheet before you start.

You can export:

single worksheets
all worksheets in a workbook
graphs associated with worksheets (except when exporting to Oracle Reports)

Notes:

When an export is complete, Discoverer's "Export Log dialog" displays a list of files created during the export, and enables you to automatically open the first export file.
Your computer platform and default settings determine which application is used to open files of different types.
Some Internet browsers impose a limitation on the number of columns that can be displayed. If you export a worksheet with a large number of columns (e.g. over 1000) in HTML format, the Internet browser might not be able to display all columns. For example, Microsoft Internet Explorer only displays up to 1000 columns.