Add multiple .csv files as sheets to an excel file in unix.

libin4u2000 · #1 (**permalink**) 01-20-2009

Hi,

I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets.

Can anyone suggest ways to do this in UNIX ?

Thanks,
David.

fpmurphy · #2 (**permalink**) 01-20-2009

Yes the are multiple ways to do what you want. Perl, Python and Ruby have the appropriate modules. Probably other scripting languages also. Depends on which scripting language you are comfortable with.

Here is a pointer to one way of doing what you want using Python: Python script to convert CSV files to Excel

Ygor · #3 (**permalink**) 01-20-2009

Also see two csv file in an excel file in two tabs

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
PERL: Split Excel Workbook to Indiv Excel files	sandeep78	Shell Programming and Scripting	2	09-25-2008 08:21 AM
How to combine different Excel sheets into a single work book using UNIX	jagadish99	Shell Programming and Scripting	3	08-27-2008 06:23 PM
How to format excel sheets in UNIX??	Vijay06	Shell Programming and Scripting	2	05-16-2007 09:01 AM
Multiple excel work sheets through UNIX	puspendu	Shell Programming and Scripting	1	05-03-2006 04:28 AM
creating more than 2 excel sheets in C	manceryder	High Level Programming	7	12-20-2005 06:10 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by