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 #25757 is a reply to message #25681]

Wed, 11 July 2001 18:57

mperrin+news
Messages: 81
Registered: May 2001

Member

Med Bennett <mbennett@indra.com> wrote:
> I use data from Excel all the time, but I always export them to a .CSV (commas
> separate values) format first. Then they can be read into IDL easily.
> 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

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: Wed Oct 08 19:25:16 PDT 2025

Total time taken to generate the page: 0.00463 seconds