A script-enabled browser is required for this page to function properly.

About spreadsheet output

Oracle Reports 10g Release 2 (10.1.2) introduces a spreadsheet output format, which enables you to generate output with rich formatting from paper layout reports to Microsoft Excel-compatible HTML format that can be directly opened with Microsoft Excel 2000 or higher.

Using the new DESFORMAT=SPREADSHEET, you can:

Note: DESFORMAT=SPREADSHEET behavior is the same as the functionality of the rw:include JSP tag. Spreadsheet output is not paginated; no page setup information is written in the output, and it is formatted as a single worksheet. Spreadsheet output is driven by the layout; the report output displays objects that are in the body area of each section (Header, Main, and Trailer) of the paper layout, and does not format any content in the margin, header, or footer areas.

Prerequisites

Usage notes

Restrictions

Example

To generate the paper layout of your report to Microsoft Excel output through a URL (using rwservlet), you can type a URL that includes the following in your browser:

http://hostname:port/reports/rwservlet?report=report_name
  +server=server_name+userid=db_connect_string+destype=file
  +desformat=spreadsheet+desname=C:\temp\myexcel_output.htm

Note: Microsoft Office 2000/2002/2003 supports Hypertext Markup Language (HTML) as a native file format. Spreadsheet output relies on producing HTML output, which can be understood by Excel as a file with valid Excel format.

Other capabilities for generating spreadsheet output

In addition to the new spreadsheet output functionality, you can also generate spreadsheet output as implemented in releases prior to Oracle Reports 10g Release 2 (10.1.2), in the following ways:

See also

Generating spreadsheet output

For choosing the appropriate delimited output solution for given requirements, see "Displaying Report Output in Microsoft Excel" in Appendix D, "Troubleshooting OracleAS Reports Services" in the Oracle Application Services Publishing Reports to the Web manual.