This content has been marked as final. Show 6 replies
If you need an actual Excel file, you have two basic options.
Option 1) Assuming your target is a recent version of Excel that supports the XML file format, you can use the PL/SQL XML generation APIs to generate a document using the Excel XML specification.
Option 2) You can use one of the Java Excel generation APIs in a Java stored procedure.
I've personally preferred option 2 because I'm more familiar with the Java libraries that generate Excel than I am with the Excel XML file specification. Your mileage may, of course, vary.
Edited by: Justin Cave on Feb 1, 2011 4:06 PM
On reflection, I imagine there must be an option 3 as well... If you're running Oracle on Windows, there must be .Net libraries that generate Excel files-- you could use those to create a .Net stored procedure that generated the Excel file. But that would be way down my personal preference list.
XLS is a propietary format, so no, other than CSV or SYLK is not possible.
You could of course have Excel to connect to Oracle or
you could use HSODBC (Oracle Hetergeneous Services using ODBC) to connect to an existing XLS file, but that would require abstracting documentation on my end, so as you don't mention a four digit version I'm not going to do that.
Senior Oracle DBA
user7351276 wrote:Can't you just open the SYLK file in Excel then Save As.. and choose XLS format, and then pivot?
Ok I have a SLK file loaded with data.
Now I open a new excel file"XLS format" and tryin to create a pivot chart based on data available in the above SLK file..
Fortunately I don't have Excel at the moment to check.
You can try to export your Data using Office 2003-XML format. There are free packages available to do so.
The format even supports pivoting, though it is not directly implemented in any of these packages.
Edited by: Marwim on 30.10.2011 01:13
Removed links to Oracle Samplecode