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
import xlrd
book = xlrd.open_workbook("univ_list.xls")
works perfectly well except that I need to replace xls with xlsx.