[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Looking for IDL code to read Excel spreadsheet
- Subject: Looking for IDL code to read Excel spreadsheet
- From: jmcfee(at)dres.dnd.ca (John McFee)
- Date: 10 Jul 2001 15:55:38 GMT
- Cache-Post-Path: coyote!unknown@peregrin
- Newsgroups: comp.lang.idl-pvwave
- Organization: Defence Research Establishment Suffield
- Reply-To: John.McFee(at)dres.dnd.ca
- Xref: news.doit.wisc.edu comp.lang.idl-pvwave:25615
I have a large number of Excel spreat sheets. They are in a very simple format.
There is a 1-line four column header, followed by four columns of numbers, eg:
Time Concentration Time2 Response
14:48:20 19.29 14:42:01 1.5
14:48:25 5.34 14:42:06 0.7
...etc.
I want to read in the numbers for processing in IDL. I could, within Excel,
export the data to an ascii file, but there are a LOT of files to do. Is there
an IDL routine that will read a simple Excel spreadsheet like this? (To make
matters worse, I run IDL on a Sun Sparcstation.)
I apologize if this has been covered in the newsgroup and I've missed it, but I
have looked in various FAQs and through the various IDL libraries and archives
on the Web and have found nothing so far.
Thanks
John McFee
--
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