MathGroup Archive 2006

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

Search the Archive

Re: Importing Several sheets from one Excel file into Mathematica


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?