Importing Several sheets from one Excel file into Mathematica
- To: mathgroup at smc.vnet.net
- Subject: [mg65011] Importing Several sheets from one Excel file into Mathematica
- From: "Trejo, Rosa M." <trejorm1 at ornl.gov>
- Date: Sat, 11 Mar 2006 05:15:51 -0500 (EST)
- Sender: owner-wri-mathgroup at wolfram.com
Hi:
I have one excel file that contains three different worksheets. When I
import the data into Mathematica it only imports the data from the first
sheet, and it ignores the rest of the sheets. Is there a way to tell
Mathematica that there is more than one sheet in this Excel file or do I
have to create separate files? The procedure I use to import the data is
the following:
Since I have several files of data to analyze, I create an array with
the file names and I import each file with a Loop that assigns each file
to a matrix (see below). I have no problems importing the data to do the
calculations, with the exception for the above mentioned. Any
information that can be provided will be greatly appreciated.
Thank you in advance,
Rosa.
(***assign files to array***)
data1={"test1.xls","test2.xls","test3.xls"};
(***Loop to Import data files into separate matrices, and arrange
matrices for calculations***)
Do[{
dat[k]=Import[data1[[k]]]; ...... ...
},{k,1,Length[data1]}];