Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
1999
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 1999

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

Search the Archive

Re: Excel

  • To: mathgroup at smc.vnet.net
  • Subject: [mg19781] Re: Excel
  • From: Dr Phillip Kent <p.kent at ic.ac.uk>
  • Date: Fri, 17 Sep 1999 01:36:39 -0400
  • Organization: Imperial College
  • References: <7rnjnk$ekd@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

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