Script to convert .xls file to .csv

spiceuser-xzcvwgjk · 2007-06-04T12:32:00.000Z

Can anyone help me how to write a KSH script to convert excel coming from source to .csv format. Thanks

spiceuser-6mqmji1d · 2007-06-05T14:14:00.000Z

I dont know what we IT guys will do without google.

There is a Perl Excel Module for Linux/Unix. You can use this. This site
has examples as well.

developer.ibm.com

IBM Developer

IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant technologies such as generative AI, data science, AI, and open source.

KSH or Normal Unix Shell scripting will not work. You have to use Perl (and
All Solaris Boxes now come with default perl enabled and installed although
a older version)

Regards
Rama Iyer
CRM Support
Ext 13152

“jalal.hajigholam
ali via
shellscript-l” To

previoustoolboxuser · 2007-06-05T14:10:00.000Z

I seem to remember that you can export from excel to .cvs
perhaps this can be done via ksh ?

anon_94355615 · 2007-06-05T13:57:00.000Z

Hi,

excel file has a lot of binary tag, and it is not simple to convert to
requested format

because with shell script you can not read binary(can read but is not
simple) file

you can write a c program(if you know exactly the exec format) for
conversion

search google, it may helpful

romeoninov-ayhja8vt · 2007-06-04T14:47:00.000Z

Excel is close format and you should search for proprietary tool for
conversion

ssunny via shellscript-l wrote:

Can anyone help me how to write a KSH script to convert excel coming from source to .csv format.

Thanks

–

Regards: Romeo Ninov

yahoo.com

Yahoo | Mail, Weather, Search, Politics, News, Finance, Sports & Videos

Latest news coverage, email, free stock quotes, live scores and video are just the beginning. Discover more every day at Yahoo!

Freedom, Sancho…

spiceuser-orpkmfwb · 2007-06-04T13:27:00.000Z

Take a look in this forums archives for several options:

http://unix.ittoolbox.com/groups/technical-functional/shellscript-l/xls-to-csv-file-1033124

Brian

On 6/4/07, ETLisUS via shellscript-l
wrote:

The only batch method that I know of is to use vbs on a windows server
You could probably run it remotely from a korn shell on a Unix system.

Ande

previoustoolboxuser · 2007-06-04T13:17:00.000Z

The only batch method that I know of is to use vbs on a windows server
You could probably run it remotely from a korn shell on a Unix system.

Ande

daveturner-5b3hvjeq · 2007-06-04T13:07:00.000Z

That wasn’t enough info. The other format has to be some type of ASCII
format.

daveturner-5b3hvjeq · 2007-06-04T12:53:00.000Z

No you can’t. An Excel file is binary unless saved in another format.

previoustoolboxuser · 2007-06-04T12:44:00.000Z

Depending on .xls file you can just move the file to a name with the new
extension

spiceuser-6mqmji1d · 2007-06-04T12:37:00.000Z

Unix doesnt recognize a excel file format. So not sure how you will even
read it in a ksh format.

The best thing to do with be is to write a Perl script, Perl has Excel
related modules you can use.

Regards
Rama Iyer
CRM Support
Ext 13152

“ssunny via
shellscript-l”