Reading excel data
- To: mathgroup at smc.vnet.net
- Subject: [mg83741] Reading excel data
- From: DBK <boydkramer at gmail.com>
- Date: Thu, 29 Nov 2007 06:33:03 -0500 (EST)
I have generated a "dat" file from a mathematica simulation. I then
brought the data back into Mathematica to graph using the code below.
All of this worked fine. Then, when I did a few manipulations in excel
on the "dat" file (adding a column of data) and resaved the file as a
tab delimited file as it was before my manipulations, the code below
does not work. I get the following error messages.
Transpose::nmtx: The first two levels of the one-dimensional list
cannot be transposed
Part::partw: Part All of the Transpose... does not exist.
I did not manipulate at all the first two columns of the "dat"
spreadsheet which I am trying to read. So, excel has changed the file
structure in some way that prevents mathematica from reading it. Any
thoughts?
base = Transpose[
ReadList["baseline.dat", Number, RecordLists -> True]][[{1, 2},
All]];
base = Transpose[base];
ListLinePlot[base]