Members   Search   Help    Register    Login   Home
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: 24
Registered: March 2007
Location: BHILAI
Junior 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: Sun Nov 8 16:32:58 CST 2009

Total time taken to generate the page: 0.27863 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.