Re: HOWTO create in UNIX a *.xlsx (M$ Excel) with data from Oracle (not CSV!)
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 22 Jun 2010 10:03:39 -0500 (CDT)
Hi Sven, > 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... I've had this same request. I ended up writing a Perl program using the handy Perl module Spreadsheet::WriteExcel. A Google search -- or just go right to search.cpan.org -- should bring you to the module with a few simple yet complete examples to hopefully get you started. HTH! GL! Rich -- http://www.freelists.org/webpage/oracle-l
- 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