comp.lang.idl-pvwave archive: archive » Re: Looking for IDL code to read Excel spreadsheet

Home » Public Forums » archive » Re: Looking for IDL code to read Excel spreadsheet

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: Looking for IDL code to read Excel spreadsheet [message #25733 is a reply to message #25681]

Thu, 12 July 2001 11:03

jmcfee
Messages: 17
Registered: August 1995

Junior Member

<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

Report message to a moderator

[Message index]

		Re: Looking for IDL code to read Excel spreadsheet By: Med Bennett on Wed, 11 July 2001 06:40
		Re: Looking for IDL code to read Excel spreadsheet By: Rick Towler on Tue, 10 July 2001 14:39
		Re: Looking for IDL code to read Excel spreadsheet By: jmcfee on Thu, 12 July 2001 11:03
		Re: Looking for IDL code to read Excel spreadsheet By: gogosgogos on Fri, 13 July 2001 10:58
		Re: Looking for IDL code to read Excel spreadsheet By: mperrin+news on Wed, 11 July 2001 18:57

Previous Topic:	Re: a vector of indices of the largest elements in a vector not exceeding the elements of some other vector
Next Topic:	3-D plotting

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Oct 10 14:27:21 PDT 2025

Total time taken to generate the page: 0.07989 seconds