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

MathGroup Archive 2009

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

Search the Archive

Error importing Excel data into Mathematica 7

  • To: mathgroup at smc.vnet.net
  • Subject: [mg100670] Error importing Excel data into Mathematica 7
  • From: Erin Noel <enoel2 at gmail.com>
  • Date: Wed, 10 Jun 2009 17:12:28 -0400 (EDT)

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. >>

It also states something about "Data" not being present in importing XLS
files.

For some reason it's trying to Join my specified path with 4 other
Mathematica System Files paths and then using that path to import the Excel
file.

I emailed Mathematica support about this issue and they were extremely
unhelpful...I booted up Mathematica holding Ctrl+Shft in order to reset the
preferences, put a "\" before the special characters in the path name, and
even uninstalled and reinstalled V7, but none of these things helped.

Has anyone experienced this problem? And if so, I would REALLY appreciate it
if anyone has any suggestions as to how to get the .xls file to import into
V7.

Thanks so much in advance,

Erin



  • Prev by Date: Re: What should be a simple task....
  • Next by Date: Re: What should be a simple task....
  • Previous by thread: Re: manipulate contourplot question
  • Next by thread: Re: Error importing Excel data into Mathematica 7