[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Looking for IDL code to read Excel spreadsheet

Organization: Defence Research Establishment Suffield

Thanks to everyone for their help. I'll export as .csv files. The less fooling 
around with MicroSoft, the better!

John McFee

In article <9ij05q$2j68$1@agate.berkeley.edu>,
 mperrin+news@arkham.berkeley.edu (Marshall Perrin) writes:
|> > I use data from Excel all the time, but I always export them to a .CSV 
|> > Alternatively, you could study one of the files with a hex editor to figure 
|> > where the data that you want actually starts and how the files are 
structured, and
|> > then use binary reads.  Good luck -
|> Don't even think about trying to do it in binary - .xls files, like .doc and
|> the rest of the MS Office file formats, are in an extremely complicated 
|> called DocFile, which basically is an entire file-system-in-a-file, complete
|> with FAT tables, directory structures, and balanced red-black trees wrapped
|> around all the actual spreadsheet data. You *don't* want to have to write a
|> parser for that mess in IDL. Stick with the CSV export - fast and easy.
|>  - Marshall

Dr. John E. McFee  
Defence Research Establishment Suffield
Box 4000, Medicine Hat, AB Canada T1A 8K6
(403) 544-4739 (voice)    544-4704 (fax)
e-mail: John.McFee@dres.dnd.ca  
Dr. John E. McFee                         | John.McFee@dres.dnd.ca
Head Threat Detection Group               | www.dres.dnd.ca, www.ccmat.gc.ca
Defence Research Establishment Suffield   | PH: 403-544-4739