Home » Developer & Programmer » Reports & Discoverer » print on specific excel sheet
print on specific excel sheet [message #410332] Fri, 26 June 2009 06:01 Go to next message
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
Member
Hello all,

I want to print data in excel file,to a specific sheet name like'XYZ'.

how to do this with ole2 object.

regards:
Sunil Madnani

Report message to a moderator

Re: print on specific excel sheet [message #410833 is a reply to message #410332] Tue, 30 June 2009 09:03 Go to previous message
kinnu
Messages: 1
Registered: June 2009
Location: HYDERABAD
Junior Member
You can print(Export) any of the data which retrieves from SQL
by using Sylk Arrays.
Just write ono SQL and can choose the file name like ABC.xls and the output directly formed into Excel cells and columns.
But you should have install the package infact its simple process.

Report message to a moderator

Previous Topic: ORACLE 10G R2 REPORTS SERVER ERROR REP-1920
Next Topic: Mailing Label Report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 04:09:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.