Computing.Net > Forums > Unix > How to conver a text file into .xls

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

How to conver a text file into .xls

Reply to Message Icon

Name: sivas.com
Date: April 2, 2007 at 00:25:58 Pacific
OS: UNIX
CPU/Ram: IBM
Product: IBM
Comment:

Hi,

How to convert a text file (which is tab delimited) into an .xls file. in unix scripting.

I tired renaming the extension of .txt into .xls. It seems to work so but the leading zeros of the cell contents are removed. I guess the cell type should be text for that. How can i achive in shelll scripting?.. Can anyone of you help me. Thanks in adavance.


Siva



Sponsored Link
Ads by Google

Response Number 1
Name: nails
Date: April 2, 2007 at 06:58:29 Pacific
Reply:

I'm certainly not an Excel expert, but I've been told that the way you save the leading zeros is to surround each column with a single quote.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Unix Forum Home


Sponsored links

Ads by Google


Results for: How to conver a text file into .xls

How to convert text file to html www.computing.net/answers/unix/how-to-convert-text-file-to-html/4709.html

how to store the output file in .xls format www.computing.net/answers/unix/how-to-store-the-output-file-in-xls-format/8402.html

Parsing and emailing a text file www.computing.net/answers/unix/parsing-and-emailing-a-text-file-/6623.html