Home » SQL & PL/SQL » SQL & PL/SQL » create excel (Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod, Windows XP)
create excel [message #412044] Tue, 07 July 2009 09:32 Go to next message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
Is there any way to create an excel file other than using OLE?
I am using OLE but it is too slow, eg 200,000 records take round about 2 hours to create an excel. So i am looking for an alternative.

[EDITED by LF: switched "title" and "product, version, OS" fields]

[Updated on: Tue, 07 July 2009 15:34] by Moderator

Report message to a moderator

Re: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod, Windows XP [message #412045 is a reply to message #412044] Tue, 07 July 2009 09:33 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
Does it have to be an xls or will a csv do?
Re: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod, Windows XP [message #412046 is a reply to message #412045] Tue, 07 July 2009 09:37 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
And do you want to Create the spreadsheet, or just add data into it?
Re: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod, Windows XP [message #412053 is a reply to message #412044] Tue, 07 July 2009 09:48 Go to previous messageGo to next message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
no we need to create an excel file only. We just need to add data and save it on the disk. The disk can be on server as well.
Re: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod, Windows XP [message #412054 is a reply to message #412044] Tue, 07 July 2009 09:55 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Output the data in XML format since Excel can read it.
Re: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod, Windows XP [message #412056 is a reply to message #412044] Tue, 07 July 2009 10:02 Go to previous message
waqasbhai
Messages: 118
Registered: August 2008
Location: Pakistan
Senior Member
Will it be faster than OLE? Can you refer me to any example for creating data into XML and then to excel?
Previous Topic: Parse
Next Topic: FOR UPDATE WAIT n
Goto Forum:
  


Current Time: Sat Dec 03 09:58:48 CST 2016

Total time taken to generate the page: 0.06152 seconds