Formatting Excel Sheet thru Oracle Forms [message #86949] |
Mon, 22 November 2004 22:39 |
Sheela Malhotra
Messages: 1 Registered: November 2004
|
Junior Member |
|
|
Hi
Can you pls help me how to format Excel out put which I get from Oracle Forms like a Report(Header, Date,etc). I am using OLE concept to generate Excel Sheet. Now I want to add Title, Column Names, Date,etc. Can anybody help??????????
|
|
|
Re: Formatting Excel Sheet thru Oracle Forms [message #86954 is a reply to message #86949] |
Tue, 23 November 2004 17:56 |
ashish
Messages: 107 Registered: December 2000
|
Senior Member |
|
|
hi sheela (forms 5)
I dont think u should use ole instade of that use text_io pkg.
create a format of the excel file in excel and then save it as SYLK then open this file in notepad.
u'll get the code for excel file ten use this code in tex_io pkg.
if u want sampal code i can mail it.
i hope this will help u .
or u can dde.execute to execute command in excel.
regards
ashish
|
|
|