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

Shell Programming and Scripting
1

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.

2

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

3

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