Home » Developer & Programmer » Reports & Discoverer » Excel output from Oracle Reports 3.0
Excel output from Oracle Reports 3.0 [message #302219] Sun, 24 February 2008 23:18 Go to next message
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 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
http://www.orafaq.com/forum/t/33414/0/
Re: OracleReport3.0!!! [message #302463 is a reply to message #302340] Mon, 25 February 2008 18:28 Go to previous messageGo to next message
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 ?
Error!!!, not able to proceed further [message #302482 is a reply to message #302219] Mon, 25 February 2008 20:12 Go to previous messageGo to next message
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
Re: OracleReport3.0!!! [message #302485 is a reply to message #302219] Mon, 25 February 2008 21:52 Go to previous messageGo to next message
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
Re: OracleReport3.0!!! [message #302532 is a reply to message #302219] Tue, 26 February 2008 01:11 Go to previous messageGo to next message
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
Re: Excel output from Oracle Reports 3.0 [message #302608 is a reply to message #302219] Tue, 26 February 2008 05:59 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Try this
Re: Excel output from Oracle Reports 3.0 [message #302725 is a reply to message #302219] Tue, 26 February 2008 18:09 Go to previous messageGo to next message
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
Re: Excel output from Oracle Reports 3.0 [message #302781 is a reply to message #302725] Wed, 27 February 2008 00:33 Go to previous messageGo to next message
Littlefoot
Messages: 21823
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).
Re: Excel output from Oracle Reports 3.0 [message #303026 is a reply to message #302219] Wed, 27 February 2008 11:38 Go to previous messageGo to next message
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.
Re: Excel output from Oracle Reports 3.0 [message #405193 is a reply to message #302219] Tue, 26 May 2009 22:30 Go to previous message
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.
Previous Topic: Total Page Number
Next Topic: How to compile report?
Goto Forum:
  


Current Time: Wed Nov 27 04:01:37 CST 2024