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

Re: Excel

• To: mathgroup at smc.vnet.net
• Subject: [mg19832] Re: Excel
• From: king at dircon.co.uk (Nigel King)
• Date: Sun, 19 Sep 1999 01:20:21 -0400
• Organization: Consultant
• References: <7rnjnk$ekd@smc.vnet.net>
• Sender: owner-wri-mathgroup at wolfram.com

Bob HYDE <bobhyde at wanadoo.fr> wrote:

> 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.
> Bob
It sounds as though the Excel Files have been saved as Excel Native
rather than tab delimited or comma delimited ie. as .txt or .csv

A simple course of action if the tables are simply data is to get your
colleagues to save them in the way you need.

-- 
Nigel King - Radio Systems Consultant, KingComm Ltd
email:  mailto://king at dircon.co.uk  web: http://www.king.dircon.co.uk/
Office:  +44 1364 642454            Mobile:  +44 7713 080166
Home:    +44 1364 642265            Fax:     +44 1364 642454