[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Looking for IDL code to read Excel spreadsheet
<9ij05q$2j68$1@agate.berkeley.edu>
Organization: Defence Research Establishment Suffield
Keywords:
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
out
|> > 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
format
|> 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