Re: Converting Excel table to Mathematica matrix.
- To: mathgroup at smc.vnet.net
- Subject: [mg8142] Re: [mg8121] Converting Excel table to Mathematica matrix.
- From: Wouter Meeussen Vandemoortele CC R&D <wmn.vdmcc at vandemoortele.be>
- Date: Fri, 15 Aug 1997 23:41:53 -0400
- Sender: owner-wri-mathgroup at wolfram.com
At 12:55 12.08.97 -0400, you wrote:
>
>How to I convert an Excel mxn table into a Mathematica mxn matrix?
>
>
hi,
I use one of two ways:
fast & dirty:
-------------
in Excel, make a CSV file, but give
the first element a "{", and add a "}" after the last one.
each time in the cell of course.
then do
<<"P:\\open\\wmn\\test.csv"
cumbersome & clean:
------------------
make a text file from Excel and do
test=ReadList["P:\\open\\wmn\\test.txt",
Number,WordSeparators->"\t",
RecordLists -> True]
of course, if you had comma's instead of tabs,
you'd say WordSeparators->","
Wouter.
NV Vandemoortele Coordination Center
Oils & Fats Applied Research
Prins Albertlaan 79
Postbus 40
B-8870 Izegem (Belgium)
Tel: +/32/51/33 21 11
Fax: +/32/51/33 21 75
vdmcc at vandemoortele.be