[Tutor] Command statement work well on interactive mode, which running as pf file it throws error object has no attribute '__getitem__'

Joseph John jjk.saji at gmail.com
Thu Jun 9 03:33:11 EDT 2016


Dear All,
I am taking my initial steps to interact Python with excel  files.
I was success in importing the needed modules, and executing steps in
interactive mode .
All my initial commands such as
import openpyxl
wb = openpyxl.load_workbook('MyTutor.xlsx')
wb.get_sheet_names()
sheet= wb.get_sheet_by_name('SQL Results')
sheet.title
print sheet.title
print sheet['A1']

All worked fine
Now when I create a *.py  file with all the above steps and run it, I am
getting error
Traceback (most recent call last):
  File "./ReadingDataFrom1X.py", line 10, in <module>
    c = sheet['A1']
TypeError: 'Worksheet' object has no attribute '__getitem__'


The contents of  “ReadingDataFrom1X.py” is as follows
 #!/usr/bin/python
import openpyxl
wb = openpyxl.load_workbook('MyTutor.xlsx')
wb.get_sheet_names()
sheet= wb.get_sheet_by_name('SQL Results')
sheet.title
print sheet.title
print sheet['A1']

If the statement worked in the interactive mode, it should all work while
executing the file created.
Did some google search, did not come across any valid reason why the error
message is showing.

Would like to request for guidance and feed back, please let me know why
all my  command statements  work on interactive mode and when I run it in a
py file some commands throws error
Thanks
Joseph John


More information about the Tutor mailing list