Re: Is it possible to generate a excel file from oracle reports ?

It is,
see csv file output in reports,
report can generate a .csv file (excell can handle), but for some complicated reports (or reports with groupping) you will find out,
that the way how reports does it, is probably not what you wanted. So create plain query and concatenate all columns you are dealing with separated by ',', do not forget to remove possible commas inside column values,
create tabular report based on this query and specify destination format csv.
Regards,
AZ.

"LionVan" <member38195_at_dbforums.com> wrote in message news:3333223.1062731949_at_dbforums.com...
>
> Originally posted by News
>
> > Is it possible to generate an excel file from oracle reports ?
>
> > I have reports version 6.0.8.11.3
>
> >
>
> > Thanks for any help
>
> > Frode
>
>
>
> Oracle report doesn't not provide such function now . But a third-part
> software called rep2excel may help you !
>
> Rep2excel is not free ! Another software which can fulfill what you want
> is available ! It is named repexpert .You can download it from
> http://repexpert.freewebpage.org/
>
>
>
> Some information about rep2excel :
>
>
>
> What is Rep2excel ?
>
> Rep2excel is running on server side , it can convert .html file
> generated by oracle report server to excel format , you can download the
> excel file via browser .That means , you can browse you report in excel
> format via IE just like report in HTML format .
>
> Rep2excel can convert report in HTML or HTMLCSS format to excel format.
>
> Why rep2excel is the best software which can convert html to excel
> ?Because it is designed for Oracle Report only !
>
>
>
> How does rep2excel runs?
>
> The current version of rep2excel is a CGI application running on win32
> platform . You can execute the application inside Apache server (oracle
> http server is based on apache server ) . After oracle report server
> output report into a html file, you can call the application to convert
> the report to excel thru web-browser
>
>
>
> For more information,please visit :
>
> http://rep2excel.freewebpage.org/
>
>
> --
> Posted via http://dbforums.com
Received on Mon Sep 08 2003 - 19:11:17 CEST