RE: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
- From: Jackie Brock <J.Brock@xxxxxxxxxxxxx>
- To: "aluoor@xxxxxxxxx" <aluoor@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Jun 2010 09:02:37 -0600
I use PERL for this - the Spreadsheet::WriteExcel module works quite well.
-Jackie
Jackie D. Brock
Database Specialist - Systems Evaluation
CableLabs(r)
858 Coal Creek Circle
Louisville, CO 80027
Email: j.brock@xxxxxxxxxxxxx
303-661-3347
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sven Aluoor
Sent: Tuesday, June 22, 2010 8:50 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not
CSV!)
Hi folks
At the moment we make CSV files in UNIX scripts. Here an example.
SELECT serial
|| ';'
|| upd_time
|| ';'
|| MESSAGE
|| ';'
|| entity_table
|| ';'
|| action
|| ';'
|| status
|| ';'
|| act_msg
|| ';'
|| rss_name
|| ';'
|| rss_type
|| ';'
|| ADMIN
FROM trans
WHERE ess_user = '00000001' AND upd_time > to_date('25/05/2010','DD/MM/YYYY')
ORDER BY serial DESC;
Is it possible to make a native Excel sheet from UNIX? We need basic
formatting of the resulting sheet.
For example the field act_msg is a VARCHAR2 with 4000 Byte. In CSV
this is a mess...
cheers Sven
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
