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

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