1

Hi, I am new in unix.i need shell script of Conversion of Excel files to Text(.csv)files. please can any one help me.

2

Do you really need a excel format. I mean can it not be renamed as a .csv
and attached and emailed. .csv will be easily opened by the excel program…

Does changing it to .csv help.

The alternate you can try is “mail.exe” download Program. Its a self
containing program that simulates mailx unix command.

The mail.exe is a freeware utility.

http://www.beyondlogic.org/solutions/cmdlinemail/cmdlinemail.htm

May be get the file to Windows box and email it from their. Or use Perl
Excel module like someone else who suggested the same.

Regards
Rama Iyer
CRM Support
Ext 13152

"dturner32257 via

shellscript-l"

3

It doesn’t. I’ve already tried this and several other options
before posting an email for everyone.

4

When you are generating the column enclose the column in quotes for eg
“00012345”. May be that will help.

Regards
Rama Iyer
CRM Support
Ext 13152

"dturner32257 via

shellscript-l"

5

I don’t recall seeing this mentioned but if you can use Perl

6

That’s a default setting in Excel. The cell has to be formatted to provide
leading zeros and is available in the .xls format only which is binary. You
can create a text file and name it .xls, but once you save it as .xls it w
ill no longer be ASCII.

This is outside the concept of script as well, but I hope this helps.

Dave

7

Hi Frdric MEYROU,

I too follow the same method but instead I create a file with extension as .xls and then mail them so that attachment opens directly in MS excel.

However, there is a small problem the leading zeroes in the columns are trimmed i.e. 001345 will appear only as 1345 is there any way to avoid this.

Thanks in advance…

8

Personally, I create files from my shell scripts with “tab” as delimiter
between the fields.
Then I send the file with the “mail” command to my outlook and a simple
copy/paste to an excel speadsheet works fine!

An other way could be to save a text file into a “.csv” file. Then when
you open it in excel, it might ask you for convertion.

Cordialement,
./Frdric MEYROU

Frdric MEYROU - UNEDIC - Site de Gradignan
DSI / DME / Ingnierie Systmes et Production (ISP)

9

As far as I know there is no shell script that could do this, however if you have Perl loaded on your server you could use a module in Perl to do this.
But like some one before said why don’t you just save the file in csv format instead of xls?

Good Luck,
Ski

10

hai thsis is Anand

i can give u suggestion that just type in google script to excel conversation tool

tq
anand
anand.b@seguesol.com

11

Hi,

As Far As I Know, There Are A Lot Of Scape Sequence Inside of Execel File

And It Is Too Difficult To Write “SHELL SCRIPT”

I Hope Somebody Send “C” Program To Solve Your Problem

On 4/4/07, Romeo Ninov via shellscript-l
wrote:

why just export sheet in csv form? actually excel format is closed, so
i am afraid you will not find (unix) toll to do the task

2007/4/4, Rao via shellscript-l :

Hi,
I am new in unix.i need shell script of
Conversion of Excel files to Text(.csv)files.
please can any one help me.

–

Regards: Romeo Ninov
Yahoo | Mail, Weather, Search, Politics, News, Finance, Sports & Videos

–
Best Regards
Jalal Hajigholamali

12

why just export sheet in csv form? actually excel format is closed, so
i am afraid you will not find (unix) toll to do the task

2007/4/4, Rao via shellscript-l

13

Please send a format of the excel file with some data.