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

[LionVan]

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

[az5]

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@dbforums.com> wrote in message
news:3333223.1062731949@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