title: Unable to import .xlsx into Python: No such file or directory
body: <p>I'm trying to import data from HW3_Yld_Data.xlsx into Python. I made sure that the Excel file is in the same directory as the Python file. Here's what I wrote:</p>
  
  <pre><code>import pandas as pd
  
  Z = pd.read_excel('HW3_Yld_Data.xlsx')
  </code></pre>
  
  <p>Here's the error I got:</p>
  
  <pre><code>In [2]: import pandas as pd
     ...: 
     ...: Z = pd.read_excel('HW3_Yld_Data.xlsx')
  Traceback (most recent call last):
  
    File "&lt;ipython-input-2-7237c05c79ba&gt;", line 3, in &lt;module&gt;
      Z = pd.read_excel('HW3_Yld_Data.xlsx')
  
    File "/Users/Zhengnan/anaconda/lib/python2.7/site-packages/pandas/io/excel.py", line 151, in read_excel
  return ExcelFile(io, engine=engine).parse(sheetname=sheetname, **kwds)
  
    File "/Users/Zhengnan/anaconda/lib/python2.7/site-packages/pandas/io/excel.py", line 188, in __init__
  self.book = xlrd.open_workbook(io)
  
    File "/Users/Zhengnan/anaconda/lib/python2.7/site-packages/xlrd/__init__.py", line 394, in open_workbook
  f = open(filename, "rb")
  
  IOError: [Errno 2] No such file or directory: 'HW3_Yld_Data.xlsx'
  </code></pre>
  
  <p>What's mind-boggling is that it used to work fine. It appeared to stop working after I did a "conda update --all" yesterday.</p>
  
  <p>BTW I'm using Spyder as IDE. Please help. Thank you.</p>