Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
- From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
- To: aluoor@xxxxxxxxx
- Date: Tue, 22 Jun 2010 18:41:11 +0100
> 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
Other related posts:
