Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2006
*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 2006

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

Search the Archive

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]}];

    



  • Prev by Date: Re: Re: General--Making the DisplayFormula style in ArticleModern look like Traditional
  • Next by Date: how can I import my datas in excel to mathematica and then do calculations on them?
  • Previous by thread: Re: Combining Matrices
  • Next by thread: Re: Importing Several sheets from one Excel file into Mathematica