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