Home » Developer & Programmer » Forms » Formatting Excel Sheet thru Oracle Forms
Formatting Excel Sheet thru Oracle Forms [message #86949] Mon, 22 November 2004 22:39 Go to next message
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 Go to previous message
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
Previous Topic: On-Error trigger not getting fired if System.Message_Level is 25
Next Topic: Associating LOV Programmaticaly
Goto Forum:
  


Current Time: Sat Sep 07 15:52:32 CDT 2024