Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
- From: Jared Still <jkstill@xxxxxxxxx>
- To: chet.justice@xxxxxxxxx, aluoor@xxxxxxxxx
- Date: Tue, 22 Jun 2010 11:38:45 -0700
On Tue, Jun 22, 2010 at 10:50 AM, chet justice <chet.justice@xxxxxxxxx>wrote:
> You could also do it from SQL*Plus if you wanted:
>
>
> http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:68212348056#15410901253486
>
>
I looked at and rejected similar methods when I needed real XLS output.
The problem is that these require too much formatting work after generating
the file.
Might as well just start out with CVS.
Along with the other responders, I used Spreadsheet::WriteExcel.
There are modules for reading and writing Excel.
Using it you can output reports with frozen frames, different color fonts if
needed, formatting, etc.
I used to to create SarbOx reports - it is not trivial to use, but the
results are files that look
the way you want and require no external editing.
Just my opinion of course, but the auditors like the reports, have have
made no suggestions for improvements.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
