Mathematica 9 is now available
Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2000
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2000

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

Search the Archive

Re: Fourier Transform & Data imported from Excel

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

Rick-

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)

-matt

In[154]:=
SetDirectory["c:\\mathematica\\datasets"]
Out[154]=
"c:\\mathematica\\datasets"
In[156]:=
data = ReadList["test1.txt", {Number, Number}];
data
Out[157]=
{{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 iinet.net.au> on 09/03/2000 08:11:06 PM

cc:
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
the
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
Rick








  • 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