|
|
|
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
|
|
|
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
|
|
|
|
|
|
|
|
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.
|
|
|