jinli@gpu.utcs.utoronto.ca (Jin Tonic Li) (11/08/89)
I am trying to save the data for one of my own application program in Microsoft Excel(Mac version) format so that I can do some simple data analysis using MS Excel. I have the following questions: 1. What are the creator and file type id's for Microsoft Excel? [I have tried 'XCEL' and 'WKS ' respectively.] 2. For worksheet files, how are the data saved?(in row or column major manner? any magic #s? special row/column delimiter? traps for # and string types?) -- Jin Li >> Gin & Tonic mix well University of Toronto Computing Services << No bugs, no bucks jinli@gpu.utcs.utoronto.ca uunet!utgpu!jinli>> For info, C Unix manual
jwright@atanasoff.cs.iastate.edu (Jim Wright) (11/08/89)
jinli@gpu.utcs.utoronto.ca (Jin Tonic Li) writes: | I am trying to save the data for one of my own application program in | Microsoft Excel(Mac version) format so that I can do some simple data | analysis using MS Excel. I did the same thing. I just set the creator to 'XCEL' and the type to 'TEXT'. You get a file that, from the finder, looks like any other orphan file. But double click on it, and Excel starts up and imports the file! | 2. For worksheet files, how are the data saved?(in row or column major manner? | any magic #s? special row/column delimiter? traps for # and string types?) This is mostly documented in the manuals. Each line of the text file is a spreadsheet row. Delimit the columns with either tabs or commas. I found tabs to work the best. There's some nonsense regarding dates, but you should be OK if you keep things consistent. My turn for a question: Is there any problem with modifying my copy of Excel so that the text files have an icon? -- Jim Wright jwright@atanasoff.cs.iastate.edu