Skip Headers

Oracle9iAS Discoverer Plus User's Guide
Version 9.0.2

Part Number A90879-02
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

16
Exporting data to other applications

This chapter explains how to export worksheet data and graphs in Discoverer, and contains the following topics:

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:

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:

Note: When you export a worksheet and a graph to Excel format, the worksheet data is displayed in the spreadsheet. The graph file (a GIF filed placed in the default drive location) can be inserted manually into the spreadsheet using Excel's Insert | Picture option.

By default, export files are created in the operating system's default file location. For example, in Windows NT, this might be c:\winnt\profiles\user name\.

Discoverer's Export Log displays a list of files created during the export.

Your computer platform and default settings determine which application is used to open files of different types.

About exporting worksheets to Oracle Reports

You can export worksheet data from Discoverer to Oracle Reports. You can then use Oracle Report's reporting features (e.g. multi-component reports, break charts) to further enhance the worksheet data.

When you export worksheets to Oracle Reports, the export file includes the Discoverer query definition used to create the worksheets. When Oracle Reports opens the export file, this query is executed and the report is refreshed with up-to-date data. In other words, you do not have to repeat the export from Discoverer to get up-to-date data in Oracle Reports.

When you export Discoverer worksheets to Oracle Reports, worksheet data is exported in the Extensible Markup Language (XML) format used by Oracle Reports. During export, Discoverer populates Oracle Report's data model, reports layout, and previewer.

Exported worksheet data is displayed in Oracle Reports. When you open an exported Discoverer report in Oracle Reports, you have everything that you need to continue to work on the report definition on a standalone machine.

Oracle Reports supports the following Discoverer features:

Table 16-1 Discoverer features supported by Oracle Reports
Discoverer feature  How it works in Oracle Reports 

calculations 

Oracle Reports preserves worksheet calculations. 

format styles and symbols 

Oracle Reports preserves the following worksheet formatting:

  • font

  • alignment

  • text color

  • background color

  • NULL value substitution

  • currency symbols

  • format masks

  • text style (e.g. upper/lower case, capitalization)

 

formatting 

Oracle Reports users can add, edit, and delete format and exception formats defined on items. 

layout 

Oracle Reports users can move items around. 

NLS 

Oracle Reports must be started using the NLS settings used in the original Discoverer worksheet. 

parameters 

Oracle Reports users can continue to use worksheet parameters. 

SQL 

Discoverer exports an easy-to-read SQL statement for each report that you can edit in Oracle Reports.

For example, you can edit SQL for calculations and totals.  

titles 

Oracle Reports preserves worksheet titles. 

totals 

Oracle Reports preserves worksheet totals, which are mapped to Oracle Reports summaries. 

worksheet items 

Oracle Reports users can edit the conditions and parameters used in the worksheet. 

Notes:

About exporting worksheets to Microsoft Excel

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.

Different versions of Microsoft Excel impose different limits on the maximum number of Discoverer rows allowed in an Excel sheet, as follows:

Table 16-2 Microsoft Excel row limits on sheets when importing Discoverer data
Microsoft Excel version  Maximum number of Discoverer rows per Excel sheet  How Microsoft Excel handles additional rows 

Excel 95 

16,380 

Any additional rows are placed on additional Excel sheets. 

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:

About how worksheets and graphs are exported

When you export a workbook containing worksheets with associated graphs, Discoverer creates worksheets and their graphs as separate files:

For example, if you export a worksheet called Sales and its graph in HTML format, Discoverer creates the following files:

Notes:

About exporting worksheets that contain page items

When you export a worksheet that contains page items, you export exactly what you see on the screen. In other words, you export data for the currently selected page item.

To export other combinations of page items, first pivot the page items and then export the modified worksheet.

If you want to export all page items, pivot the page item to the body of the worksheet so that all page items are visible on the worksheet.

About accessing exported files

When you export data from Discoverer, you can start the application associated with the format of exported data. For example, when you export to Excel format, you can start Microsoft Excel (for more information, see the "Export Wizard: Log dialog").

How to export Discoverer data

You export worksheet data so that you can use the data in a Discoverer worksheet in a different application.. For example, you might want to produce a Discoverer worksheet and graph in HTML format.

To export worksheet data:

  1. Open the worksheet that you want to export.

  2. Choose File | Export to display the "Export Wizard: Select Objects dialog".

  3. Use the "Export Wizard: Select Objects dialog" to specify which parts of the workbook you want to export.


    Text description of expwiz1.gif follows.
    Text description of the illustration expwiz1.gif

    For example, you might want to export only the current worksheet and its graph, or you might want to export all worksheets in the workbook.

    Hint: If you export all the worksheets in a workbook, make sure that each worksheet currently displays the combination of page items that you want.

  4. Use the "Export Wizard: Define File Details dialog" to specify which export format to use and specify where to save the export files.


    Text description of expwiz2.gif follows.
    Text description of the illustration expwiz2.gif

  5. If you are exporting graphs, use the "Export Wizard: Define Graph dialog" to specify graph options.


    Text description of expwiz3.gif follows.
    Text description of the illustration expwiz3.gif

    For example, you might want to preserve the graphs' height and width ratios, or the on screen font size.

    Note: If you export more that one graph, these options affect all graphs exported.

  6. If the worksheet contains parameters, you can restrict the data that you export by entering a parameter value on "Export Wizard: Edit Parameter Values dialog").

    For example, you might want to export data for a single year, or export data for all years.

  7. Use the "Export Wizard: Supervise dialog" to choose whether or not to supervise the export to confirm warning messages.


    Text description of expwiz4.gif follows.
    Text description of the illustration expwiz4.gif

    For example, in Supervised mode, if you exceed the maximum number of rows allowed in a query, a warning message is displayed. You can confirm this warning by clicking OK or click Cancel to stop the process.

  8. Click Finish to start the export.

    Discoverer displays the "Export Wizard: Log dialog", which displays a list of files created during the export.


    Text description of expwiz5.gif follows.
    Text description of the illustration expwiz5.gif

  9. If you want to open the first export file in its associated application, select the Open the first exported sheet check box.

  10. Click OK to close the Export Log.

If you selected the Open the first exported sheet check box on the "Export Wizard: Log dialog", the Discoverer data is automatically displayed in an appropriate application. For example, if you export to HTML format, the first sheet is automatically displayed in an Internet browser.

Notes:


Go to previous page Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index