2
$\begingroup$

I was able to IMPORT from excel data at the start of my project when both the .nb and EXCEL XLS files were sitting in MyDocument (or some other location), but upon moving both files into my Dropbox location, when I opened my .nb file again, IMPORT fails with 'File not found during Import'? I assume having both in the same directory is not suffice, but rather IMPORT only looks for file as defined by path setting within Mathematica? If so how to change it so that regardless of where I put the .nb and excel files, as long as they are both in the same directory I can do IMPORT?

Improve this question
$\endgroup$
3
  • $\begingroup$ look up ref/$Path $\endgroup$
    – Mike Honeychurch
    Dec 12, 2012 at 23:56
  • $\begingroup$ AppendTo[$Path, NotebookDirectory[]] $\endgroup$
    – Rolf Mertig
    Dec 13, 2012 at 0:13
  • $\begingroup$ HI @Rolf it works! and so use if I again move the .nb and excel file again to a CD /DVD disk, then this command at the first line will also do the same and append path I assume. $\endgroup$
    – sebastian c.
    Dec 13, 2012 at 0:19

1 Answer 1

Reset to default
5
$\begingroup$

If the file you wish to import will always be kept in the same directory as your Mathematica notebook you may do:

Import[NotebookDirectory[] <> "filename"]

or 

Import[FileNameJoin[{NotebookDirectory[], "filename"}]]
Improve this answer
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.