OraFAQ Forum: Forms » Trying to get data in Excel sheet from Oracle reports 10g

Home » Developer & Programmer » Forms » Trying to get data in Excel sheet from Oracle reports 10g (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trying to get data in Excel sheet from Oracle reports 10g [message #574524]

Fri, 11 January 2013 11:34

user888
Messages: 3
Registered: February 2012
Location: Chicago

Junior Member

Hi All,
I am newbie in Oracle Reporting. I have a requirement to give EXCEL Output from Oracle reports 10g. The rdf which was already existing is giving pdf output. The users were interested in Excel Output and I am facing hard time here. I googled and got a few threads regarding this, none of them ended up with exact solution. Kindly let me know the solution for this.
You can find the attachment for Built in packages I have in the form Builder. Please suggest me, if there is any package is needed for this task.
Thanks a lot in advance.

Attachment: packages.JPG
(Size: 37.60KB, Downloaded 2459 times)

Report message to a moderator

Re: Trying to get data in Excel sheet from Oracle reports 10g [message #574538 is a reply to message #574524]

Fri, 11 January 2013 20:29

chakrioradba
Messages: 1
Registered: January 2013
Location: Hyderabad

Junior Member

Use PDF to Excell converter tool

Report message to a moderator

Re: Trying to get data in Excel sheet from Oracle reports 10g [message #574539 is a reply to message #574538]

Fri, 11 January 2013 20:33

user888
Messages: 3
Registered: February 2012
Location: Chicago

Junior Member

My requirement is to get EXCEL report from Report Builder or from the UI and not using any third party tool. Any other suggestion are welcome.
Thanks.

Report message to a moderator

Re: Trying to get data in Excel sheet from Oracle reports 10g [message #574973 is a reply to message #574539]

Thu, 17 January 2013 05:16

haku
Messages: 3
Registered: January 2013

Junior Member

use delimiteddata

Report message to a moderator

Re: Trying to get data in Excel sheet from Oracle reports 10g [message #575813 is a reply to message #574973]

Mon, 28 January 2013 01:57

ruthran
Messages: 2
Registered: January 2013
Location: bangalore

Junior Member

I got your requirement. pls find the below link.
www.formsmigration.com/webutil1.html

Kind Regards
Ruthran

Report message to a moderator

Re: Trying to get data in Excel sheet from Oracle reports 10g [message #575849 is a reply to message #575813]

Mon, 28 January 2013 07:36

deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE

Senior Member

Hi,
You can use Quote:

client_Text_IO.Put_Line

from Forms.
Or change the system parameter DESTFORMAT value to 'SPREADSHEET' from Reports

Report message to a moderator

Re: Trying to get data in Excel sheet from Oracle reports 10g [message #665050 is a reply to message #574524]

Sun, 20 August 2017 09:17

Louis2017
Messages: 1
Registered: August 2017

Junior Member

Hi,

I think the best way is convert your Oracle report output to Excel.
First please output oracle report to html/htmlcss format, set desformat=html.
And then, call a tool named Rep2excel to convert the output (file or stream) to Excel.

No coding, no changing your report.

Please search google for Rep2excel and download the software.

Regards,
Louis

Report message to a moderator

Re: Trying to get data in Excel sheet from Oracle reports 10g [message #665056 is a reply to message #665050]

Sun, 20 August 2017 19:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Louis2017 wrote on Sun, 20 August 2017 07:17

Hi,

I think the best way is convert your Oracle report output to Excel.
First please output oracle report to html/htmlcss format, set desformat=html.
And then, call a tool named Rep2excel to convert the output (file or stream) to Excel.

No coding, no changing your report.

Please search google for Rep2excel and download the software.

Regards,
Louis

I doubt that after 4.5+ YEARS the OP will benefit from your sage advice.

BTW, you never get a second chance to make a first impression.

Report message to a moderator

Previous Topic:	Update record in detail block
Next Topic:	The cause of ora-01403 no data found error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 10:51:31 CST 2025