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
- Follow-Ups:
- Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
- From: chet justice
- Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
- From: Sreejith S Nair
- Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
- References:
Other related posts:
- » HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - Sven Aluoor
- » RE: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - Jackie Brock
- » Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - Rich Jesse
- » Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - Subodh Deshpande
- » Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - Nigel Thomas
- » Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - chet justice
- » Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - Jared Still
- » Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - Sreejith S Nair
- » Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - Sreejith S Nair
- » Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!) - Sven Aluoor