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