Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

How to conver a text file into .xls

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

Name: nails
Date: April 2, 2007 at 06:58:29 Pacific

+1

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.

parsing using Korn

Two files showing mismatc...

Post Locked

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

Summary: Hi, I would like to know how to convert a text file in UNIX to HTML using awk? For example, my file has the following contents : Name Age A 23 B 16 C 60 D 29 How to output as ...

Summary: Hi, i have ksh script to fetch the data from oracle database and store the output in a .xls or .csv file. But the output having more then 70,000 rows. How can i store those files in .xls or csv files....

Summary: I have a customer with SCO Unix and Windows . He has is a program that can create a large textfile. What he will use this program for is to create a text file that will contain a large amount of cu...