MathGroup Archive 1999

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

Search the Archive

Re: Excel


Bob HYDE wrote:
> 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 should be an easy task - check out

http://metric.ma.ic.ac.uk/mathematica/studies/CS4.html

for info.

Mathematica will not handle native "xls" files. Either you
or your colleagues will need to use "save as" within Excel
to produce a plain text data format, such as comma-separated
or tab-separated values.


-Phillip

----------------------------------+----------------------------
 Dr Phillip Kent                  | tel +44 (0)171 594 8503  
 Mathematics Dept (METRIC Project)| fax +44 (0)171 594 8517
 Imperial College                 | p.kent at ic.ac.uk 
 London SW7 2BZ, U.K.             | http://metric.ma.ic.ac.uk/
----------------------------------+----------------------------
 "We would like to have a theory of the obvious"-Andrea diSessa


  • Prev by Date: Re: Re: Mathematica can't win against TigerWoods
  • Next by Date: Re: Mathematica always writes some functions with their names
  • Previous by thread: Re: Excel
  • Next by thread: Re: Excel