- To: mathgroup at smc.vnet.net
- Subject: [mg19776] Re: Excel
- From: paulh at wolfram.com (P.J. Hinton)
- Date: Fri, 17 Sep 1999 01:36:36 -0400
- Organization: "Wolfram Research, Inc."
- References: <email@example.com>
- Sender: owner-wri-mathgroup at wolfram.com
In article <7rnjnk$ekd at smc.vnet.net>, Bob HYDE <bobhyde at wanadoo.fr> writes:
>Goodmorning all, I have been reading all your diverse problems with
>interest hoping one would coincide with mine. But ......
>My colleagues have started sending me data in tables of microsoft
>Excel (dont ask). I need to open and read this data to process it in
>I do use Openread and Read etc. for other files, I havent found a way of
>opening Excel files. Can anyone help ? Normally the file contains two
>columns of Real numbers, Surely I do not need to buy the Mathematica Excel
>package for this.
Ask your colleague to kindly send you the data in a nonproprietary
format. It is quite easy to have Excel save a worksheet in plain
text format with tab delimitations. Once you have it in this format,
You can use ReadList to pull the data in. The extra mouse clicks
he performs on his side is a small sacrifice in time when compared
to the effort needed to develop a full-blown .xls format interpreter.
Mathematica Programming Group paulh at wolfram.com
Wolfram Research, Inc.
Disclaimer: Opinions expressed herein are those of the author alone.
Prev by Date:
Can't get the 3rd Bessel zero!
Next by Date:
Previous by thread:
Next by thread: