Message-ID: <38910D9C.3C5DC9F8@americasm10.nt.com>
Date: Thu, 27 Jan 2000 22:31:40 -0500
From: "Ian Chapman" <ichapman AT nortelnetworks DOT com>
Organization: Nortel Networks
X-Mailer: Mozilla 4.7 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.os.msdos.djgpp
To: djgpp AT delorie DOT com
Subject: Re: MS Excel File format?
References: <388626BD DOT 2EA5227C AT greenbelt DOT com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Reply-To: djgpp AT delorie DOT com

Hi Ed,
    I'm doing this all the time.  Just open the file as a DELIMITED file
then in the next window that pops up choose TAB or COMMA, or SPACE or some
thing.  The file you open is a dot.txt file and it looks like this:-
1234TAB567TAB166.334TAB22.99cr
next line as above.  Use whatever delimiter you like (I prefer the comma
",") to separate the cells in a row and cr puts you onto the next row.  Oh
yes once it's open you can use the ms stuff to make it look neat and save
it as a dot.xls file.

        You can use all the text goodies that come with djgpp, grep, tr,
cat, sort etc. really good stuff for bashing text files into shape.

        Regards Ian.

Ed James wrote:

> I don't suppose anyone can give me a clue where I can find file format
> docs for Excel, either version 2.1, 3 or 4?  I'm doing a program that
> generates an Excel file "on-the-fly" to be sent to another system and
> opened by Excel.  Microsoft's site itself has not been particularly
> useful.  TIA