Search code examples
pythonexcelxlrd

python: no such file or directory error


import xlrd
book = xlrd.open_workbook("univ_list.xls")

I'm new to python. I'm trying to read a MS excel file that is in the same directory as my python script. Running the above code gives me a no such file or directory error.

I'll provide more information if needed.

Edit: code with full path upon request

import xlrd
book = xlrd.open_workbook("D:\Python_Scripts\univ_list.xls")

with corresponding error message

enter image description here


Solution

  • import xlrd
    book = xlrd.open_workbook("univ_list.xls")
    

    works perfectly well except that I need to replace xls with xlsx.