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

[Alan Gauld]

On 09/06/16 10:03, Joseph John wrote:

> itsupport at Server-A:~$ cat ReadingDataFrom1X.py
> #!/usr/bin/python
> import openpyxl
> wb = openpyxl.load_workbook('1XDataUserMDN.xlsx')
> wb.get_sheet_names()
> sheet= wb.get_sheet_by_name('SQL Results')
> sheet.title
> print sheet.title
> print sheet['A1']

I can't see anything obvious and since this is not part
of the standard library I suggest you try asking on the
support site for openpyxl.

http://groups.google.com/group/openpyxl-users

hopefully they can figure out what's happening.

-- 
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos