import xlrd
file_location = "D:\Training\Python\Email\aa.xlsx"
workbook = xlrd.open_workbook(file_location)
sheet = workbook.sheet_by_index(0)
print sheet

Error:
    workbook = xlrd.open_workbook(file_location)
  File "C:\Python27\lib\site-packages\xlrd-1.0.0-py2.7.egg\xlrd\__init__.py", li
ne 422, in open_workbook
    ragged_rows=ragged_rows,
  File "C:\Python27\lib\site-packages\xlrd-1.0.0-py2.7.egg\xlrd\xlsx.py", line 7
84, in open_workbook_2007_xml
    ensure_elementtree_imported(verbosity, logfile)
  File "C:\Python27\lib\site-packages\xlrd-1.0.0-py2.7.egg\xlrd\xlsx.py", line 5
2, in ensure_elementtree_imported
    Element_has_iter = hasattr(ET.ElementTree, 'iter')
AttributeError: 'module' object has no attribute 'ElementTree'

(Nov-09-2018, 02:42 PM)ichabod801 Wrote: Your file location string looks like it might be a problem. The backslashes will generally try to make the next character into a special character. Try one of the following: double all the backslashes (\\), switch to forward slashes (/), or make it a raw string by putting an r before it (r"D:\Training\...").

Otherwise that code is working for me in 2.7.

Error:
un(shallow)copyable object of type <type 'element'>

(Nov-11-2018, 03:30 AM)ichabod801 Wrote: Please post the full error text when posting tracebacks.