Re: Error importing Excel data into Mathematica 7
- To: mathgroup at smc.vnet.net
- Subject: [mg100683] Re: Error importing Excel data into Mathematica 7
- From: Albert Retey <awnl at gmx-topmail.de>
- Date: Wed, 10 Jun 2009 20:36:51 -0400 (EDT)
- References: <h0p7fl$g5$1@smc.vnet.net>
Hi,
> I have a number of programs that were originally written in V6 that import
> data from .xls files such as:
>
> path="C:\Users\Erin\Desktop";
> data=Import["datafile.xls",{"Data",1},Path->path];
> This series of commands has never failed to import the data just fine into
> version 6. Running the exact same code in version 7, though, results in the
> following error:
>
> Get::path: Join[C:\Users\Erin\Desktop,{C:\Documents and
> Settings\JM27373\Application
> Data\Mathematica\SystemFiles\Kernel\SystemResources\,C:\Documents and
> Settings\JM27373\Application
> Data\Mathematica\SystemFiles\Kernel\SystemResources\Windows\,C:\Documents
> and Settings\All Users\Application
> Data\Mathematica\SystemFiles\Kernel\SystemResources\,C:\Documents and
> Settings\All Users\Application
> Data\Mathematica\SystemFiles\Kernel\SystemResources\Windows\,C:\Program
> Files\Wolfram
> Research\Mathematica\7.0\SystemFiles\Kernel\SystemResources\,C:\Program
> Files\Wolfram
> Research\Mathematica\7.0\SystemFiles\Kernel\SystemResources\Windows\}] in
> $Path is not a string. >>
from the error message one can guess that Path->{path} could work and it
does indeed.
> It also states something about "Data" not being present in importing XLS
> files.
this also happened for me after I tried your code. It goes away when you
restart Mathematica and try the above with the enclosing {}. Looks like
the Join-bug messes up the whole import function once it is triggerd...
hth,
albert