Excel-Output from Oracle Reports 6i

[Rudi Ernst]

High all,

is there any possibility to create an Excel xls-file as
output from Oracle Reports 6i. I'm only able to create a
csv-file that contains an additional report header for
every row of the report and this is very annoying.

Thanks
Rudi

[Ryan]

yeah, but it can get ugly. you have to set the mode=character, and the
header(I forget the exact syntax for this) to no.
then you can call the report using DDE. and run_report_object

there are few problems with this though.

1. Reports does a HORRIBLE job exporting header data. It can only get the
data from the body. You will have to export any header data to a seperate
file with the text_io package.

2. When you use character mode you will often get a really vague error
telling you that some of your objects have no size. The way I found to fix
this is to change from what ever size standard I was using(ie inches) to the
smallest one possible. ITs a long story why this happens. There are a
variety of other reasons why this happens.

search dejanews.com... alot of people have hit these problems in the past.

Keep in mind... that if your in web mode, the report will be exported to the
application server. To get around this, I installed excel on the server,
built templates for my excel reports and put macros in them that I called
when I called the templates to import the data and used web.show_document to
allow the users to view it in their browsers. Then they could save it
locally.

Its far more annoying than it should. It would be easier just to buy a tool
called SQL*XL or something like that. Its about $100. You will need to
install the OO4O to get it to work.

"Rudi Ernst" <ne...@edv-ernst.de> wrote in message
news:m5fvfucoaj23urv28...@4ax.com...

[Jeroen Dekker]

I am no Oracle expert (so this suggestion may not make sense at all),
but i know we have customers who use our (commercial) PS2text software
to bring Oracle Reports output into Excel. It takes the PostScript
printer file that Oracle generates for printing a report, and batch
converts it to a formatted ASCII text file that retains the placement of
the text strings. This text file can be imported into Excel, which
intelligently determines the columns.

PS2text is available as a simple command line tool that can be set up on
the server (Windows, UNIX) for an automated batch process. More info is
at http://www.square1.nl/index.htm

Jeroen Dekker
jer...@square1.nl

[Gerrit-Jan Linker]

> Its far more annoying than it should. It would be easier just to buy a tool
> called SQL*XL or something like that. Its about $100. You will need to
> install the OO4O to get it to work.

SQL*XL can use ODBC and OLEDB as well now besides OO4O. It is
therefore also possible to get data from other databases.

Read more about SQL*XL at www.oraxcel.com

Thanks, Gerrit-Jan Linker