[Date Index] [Thread Index] [Author Index]

Re: Excel

• 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: <7rnjnk$ekd@smc.vnet.net>
• 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
>Mathematica. Although
>
>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.

--
P.J. Hinton
Mathematica Programming Group           paulh at wolfram.com
Wolfram Research, Inc.
Disclaimer: Opinions expressed herein are those of the author alone.