OraFAQ Forum: Reports & Discoverer » Excel output from Oracle Reports 3.0

Home » Developer & Programmer » Reports & Discoverer » Excel output from Oracle Reports 3.0

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

Excel output from Oracle Reports 3.0 [message #302219]

Sun, 24 February 2008 23:18

ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore

Member

Hi All,

Whether its possible to export the data from oracle reports3.0 to excel? How?
Thanks.

bye
Karthik

[MERGED by LF. Please, do not open a new topic when discussing the same problem]

[Updated on: Tue, 26 February 2008 01:46] by Moderator

Report message to a moderator

Re: OracleReport3.0!!! [message #302340 is a reply to message #302219]

Mon, 25 February 2008 05:05

spmano1983
Messages: 269
Registered: September 2007

Senior Member

http://www.orafaq.com/forum/t/33414/0/

Report message to a moderator

Re: OracleReport3.0!!! [message #302463 is a reply to message #302340]

Mon, 25 February 2008 18:28

ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore

Member

I saw your link.
Its working oracle reports6i, but not working in reports3.0. So my doubt is whether its possible in EXCEL or not ?

Report message to a moderator

Error!!!, not able to proceed further [message #302482 is a reply to message #302219]

Mon, 25 February 2008 20:12

ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore

Member

Hi All,

Procedure Setwdith(p_col number, p_width number) is
Begin
v_lst := ole2.create_arglist;
ole2.add_arg(v_lst,p_col);
v_cell := ole2.get_obj_property(v_worksheet,'cells',v_lst);
ole2.set_property(v_cell,'ColumnWidth', p_width);
ole2.destroy_arglist(v_lst);
ole2.release_obj(v_cell);
End SetWidth;

I'm trying to setwidth in excel, its throwing error in the 3rd line number (v_lst := ole2.create_arglist). May I know the reason, why it's not able to create in OracleReport3.0? Is there any other way? Thanks in advance.

bye
karthik

Report message to a moderator

Re: OracleReport3.0!!! [message #302485 is a reply to message #302219]

Mon, 25 February 2008 21:52

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Hi,

in Report 3.0, first you have to generate a report as a file. it will be stored as a text file.. then from excel you can import this text file.

Thanks
Mano

Report message to a moderator

Re: OracleReport3.0!!! [message #302532 is a reply to message #302219]

Tue, 26 February 2008 01:11

ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore

Member

Hi Mano,

Right now we are doing the same you said, but actually we wanted to avoid writing into text file and directly to be written into excel file.
Please refer the below post, posted by me
http://www.orafaq.com/forum/t/97918/113349/

-Karthik

Report message to a moderator

Re: Excel output from Oracle Reports 3.0 [message #302608 is a reply to message #302219]

Tue, 26 February 2008 05:59

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Try this

Report message to a moderator

Re: Excel output from Oracle Reports 3.0 [message #302725 is a reply to message #302219]

Tue, 26 February 2008 18:09

ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore

Member

I saw the link, but the spreadsheet property setting is for latest version, not for oraclereports3.0. I'm looking solution for oracle reports3.0 version.

-Karthik

Report message to a moderator

Re: Excel output from Oracle Reports 3.0 [message #302781 is a reply to message #302725]

Wed, 27 February 2008 00:33

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Reports 3.0 are quite old, aren't they? Perhaps there, actually, isn't a way to do that as you'd like it to. Maybe you'll have to end up with @spmano1983's suggestion - create output to a file which will be opened in Excel (with possible adjustments).

Report message to a moderator

Re: Excel output from Oracle Reports 3.0 [message #303026 is a reply to message #302219]

Wed, 27 February 2008 11:38

doss_arun
Messages: 10
Registered: February 2008
Location: iselin, new jersey

Junior Member

hi to all,

u can use the OLE concepts for export, import and manipulate the data from excel to report & report to excel.

Report message to a moderator

Re: Excel output from Oracle Reports 3.0 [message #405193 is a reply to message #302219]

Tue, 26 May 2009 22:30

vjman
Messages: 1
Registered: May 2009

Junior Member

At www.more4apps.com you can download a PL/SQL package called Excel-Out that installs a concurrent request with output that opens directly to Excel. The query is listed in one of the fields on the form and you can change it to create your own report with direct Excel output.

Report message to a moderator

Previous Topic:	Total Page Number
Next Topic:	How to compile report?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:14:47 CDT 2024