MathGroup Archive 2007

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

Search the Archive

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]


  • Prev by Date: Re: Question about GUIkit and creating Tabs
  • Next by Date: Re: Controlling evaluation
  • Previous by thread: TwoAxisListPlot for V6?
  • Next by thread: Re: Reading excel data