How to create Charts ino Excel using stored procedure [message #407695] |
Thu, 11 June 2009 02:35  |
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   |
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.
|
|
|
|
|
|
|