MathGroup Archive 2000

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

Search the Archive

Re: Fourier Transform & Data imported from Excel

  • To: mathgroup at
  • Subject: [mg25077] Re: [mg25047] Fourier Transform & Data imported from Excel
  • From: Matt.Johnson at
  • Date: Thu, 7 Sep 2000 22:28:25 -0400 (EDT)
  • Sender: owner-wri-mathgroup at


I've had to deal with this and its a pain.  But the best way I've found is:

1.  get your data into columns with no headings.  (headings can be removed when reading the file, but its easier just to leave them off)
2.  save the sheet as a txt file (I saved mine in "c:\\mathematica\\datasets" )
3.  follow the example below (this was for 2 columns of data)


data = ReadList["test1.txt", {Number, Number}];
{{1, 0.841471}, {2, 0.909297}, {3,
    0.14112}, {4, -0.756802}, {5, -0.958924}, {6, -0.279415}, {7,
    0.656987}, {8, 0.989358}, {9, 0.412118}, {10, -0.544021}}

"Richard Bartlett" <bartlett at> on 09/03/2000 08:11:06 PM

Subject: [mg25077]  [mg25047] Fourier Transform & Data imported from Excel

I am trying to conduct some Fourier Analysis on data that I have in Excel
2k. Any comments on the best method to bring the data across rather than
long labourious task of cut and paste. I have tried using the mathematica
help files to help with import, but they mention using .dat files which
Excel does not have that export property

Many Thanks

  • Prev by Date: Hidden parts of a curve as dashed
  • Next by Date: Re: Mathematica Publication Question
  • Previous by thread: Re: Fourier Transform & Data imported from Excel
  • Next by thread: Re: Re: A Functional Programming Question