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