Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
- From: Sreejith S Nair <Sreejith.Sreekantan@xxxxxxxxxx>
- To: nigel.cl.thomas@xxxxxxxxxxxxxx
- Date: Wed, 23 Jun 2010 09:53:30 +0530
Also Have a look at a simple macro which exports Database structures to
Microsoft Excel here.Its a good stuff.Not sure if it is relevant in this
context though !
http://dbmodelexcel.codeplex.com/
Best Regards,
Sreejith Nair
From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
To: aluoor@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Date: 06/22/2010 11:11 PM
Subject: Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data
from Oracle (not CSV!)
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
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. I'm using it at the moment, both for reading and
writing Excel spreadsheets (xls and xlsx both supported).
HTH
Regards Nigel
DISCLAIMER:
"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."
Other related posts:
