Mathematica 9 is now available
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

Re: Importing Several sheets from one Excel file into Mathematica

  • To: mathgroup at smc.vnet.net
  • Subject: [mg65093] Re: Importing Several sheets from one Excel file into Mathematica
  • From: Mike <m.HoneychurcNOSPAMh at uq.edu.au>
  • Date: Tue, 14 Mar 2006 06:00:14 -0500 (EST)
  • Organization: University of Queensland
  • References: <dv312i$r2h$1@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

On 13/3/06 3:48 PM, in article dv312i$r2h$1 at smc.vnet.net, "David Annetts"
<davidannetts at aapt.net.au> wrote:

> Hi Rosa,
> 
>> 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:
> 
> For Mathematica 5.2 & Excel 2003 (XP), I can import data from an XLS file
> which contains multiple sheets using Import["c:/Path/To/filename.xls"].
> What version(s) are you using?

Likewise 5.2 on a Mac. When I import an excel file each sheet is contained
in a a part of the resultant list. eg:

Ls=Import["file.xls"];

Ls[[1]] is sheet 1 of file.xls; ls[[2]] is sheet 2 of file.xls and so on.

Mike


  • Prev by Date: Re: Graphics Text background problem
  • Next by Date: Re: DelaunayTriangulation and Quadrangulation
  • Previous by thread: Re: Importing Several sheets from one Excel file into Mathematica
  • Next by thread: how can I import my datas in excel to mathematica and then do calculations on them?