Home » SQL & PL/SQL » SQL & PL/SQL » How to create Charts ino Excel using stored procedure
How to create Charts ino Excel using stored procedure [message #407695] Thu, 11 June 2009 02:35 Go to next message
samtajain
Messages: 7
Registered: November 2008
Junior Member
Hi There

I need some help in one of the report requirement. The report will have some static content at the top,certain charts drawn from the data stored in the Oracle database at the center and then rest of the information from the database at the end of the excel sheet.

Please let me know if this is possible to achieve through a stored procedure and how?.

NEED IT SOON.

Thanks in advance...
Re: How to create Charts in Excel using stored procedure [message #407696 is a reply to message #407695] Thu, 11 June 2009 02:42 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I don't believe this is possible. SYLK (the spreadsheet data exchange format suppported by Tom Kytes OWA_SYLK package) doesn't support anything more complex than formulae, and that's the most complex spreadsheet interaction software I know of.

The two things I can think of are:
1) Set up an ODBC connection to your Oracle Db, create a spreadsheet with the graphs you want, and get the spreadsheet to pull data out of the database.

2) Set up oracle HS server, create the spreadsheet with the graphs in it, and an ODBC connection to that spreadsheet, and use Oracle HS server to push the data to the spreadsheet.

Re: How to create Charts ino Excel using stored procedure [message #407842 is a reply to message #407695] Thu, 11 June 2009 18:40 Go to previous messageGo to next message
coleing
Messages: 213
Registered: February 2008
Senior Member
This may be possible.

Create your chart in excel. Save the spreadsheet as an XML spreadsheet, and see if you can replicate the XML in your stored procedure.

it wont be really easy, but it should be possible to create the desired xml, and use utl_file to output the results.

We use xml spreadsheets all the time using marcus matzbergers package. its a million times better than the OWA Sylk stuff that has been around for years.

See here for examples:-
http://matzberger.de/oracle/spreadsheet-en.html
Re: How to create Charts ino Excel using stored procedure [message #407868 is a reply to message #407695] Fri, 12 June 2009 01:28 Go to previous messageGo to next message
samtajain
Messages: 7
Registered: November 2008
Junior Member
Hi

Thanks for the idea. I tried saving the excel sheet as XML spreadsheet but then MS Excel expect us to map the XML elements and XSD.With a chart in excel how shall I do that.

Regards
Samta
Re: How to create Charts ino Excel using stored procedure [message #407980 is a reply to message #407695] Fri, 12 June 2009 11:48 Go to previous messageGo to next message
coleing
Messages: 213
Registered: February 2008
Senior Member
Red Herring - Charts are not supported in the XML spreadsheet format Sad

Sorry about that. Shame that....

http://office.microsoft.com/en-us/excel/HA010346391033.aspx
Re: How to create Charts ino Excel using stored procedure [message #408082 is a reply to message #407695] Sat, 13 June 2009 12:33 Go to previous message
samtajain
Messages: 7
Registered: November 2008
Junior Member
No worries...can anyone help me out here with any other suggestion please.
Previous Topic: Monthly Running Totals (merged)
Next Topic: Query to select a column value fro which other column is highest.
Goto Forum:
  


Current Time: Sat Dec 10 18:49:56 CST 2016

Total time taken to generate the page: 0.14225 seconds