Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Tue, 22 Jun 2010 18:41:11 +0100
Message-ID: <AANLkTimKr5p5uWxfnS0Y73b4syBLrULMAA5uMpkNWYpl_at_mail.gmail.com>
> 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...
>
>
> as well as Perl, you can also use the Apache POI libraries, which give a
Java interface (works fine on any platform). See *Apache POI* - the *Java*API for Microsoft Documents.<http://poi.apache.org/>I'm using it at the moment, both for reading and writing Excel spreadsheets (xls and xlsx both supported).
Date: Tue, 22 Jun 2010 18:41:11 +0100
Message-ID: <AANLkTimKr5p5uWxfnS0Y73b4syBLrULMAA5uMpkNWYpl_at_mail.gmail.com>
> 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...
>
>
> as well as Perl, you can also use the Apache POI libraries, which give a
Java interface (works fine on any platform). See *Apache POI* - the *Java*API for Microsoft Documents.<http://poi.apache.org/>I'm using it at the moment, both for reading and writing Excel spreadsheets (xls and xlsx both supported).
HTH Regards Nigel
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 22 2010 - 12:41:11 CDT