Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2009

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

Search the Archive

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


  • Prev by Date: Presentation quick with grid and pasted graphic
  • Next by Date: Strange problem with ImageApply on byte images when Interleaving is
  • Previous by thread: Error importing Excel data into Mathematica 7
  • Next by thread: Draw a 3D surface