On Thu, Jun 9, 2016 at 12:07 PM, Alan Gauld via Tutor <tutor@python.org> wrote:
> On 09/06/16 08:33, Joseph John wrote: > > > 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'] > > Not according to the error message. It says the error > is on the line: > > c = sheet['A1'] > > But you don't have such a line. > > So the code you sent us is not the code you are running. > Why that may be is the puzzle. > Do you have more than one file called ReadingDataFrom1X.py? > > How are you running the code? Is it from an IDE such as IDLE? > Or from the OS command line? That might make a difference. > > Hi Alan, Thanks for the reply. I have only the same file, what happened is that I was editing the file in a editor for troubleshooting and when I run the file it was not saved, I was trimming the code to the minimum Now the program file has only the #!/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'] and when I run it from the command line, it gets this error Traceback (most recent call last): File "./ReadingDataFrom1X.py", line 8, in <module> print sheet['A1'] TypeError: 'Worksheet' object has no attribute '__getitem__' I also suspect that my user python installation has issues. I will test it I will test it on another user environment and see how it comes and give the feedback on a separate thread Thanks a lot Joseph John > > > -- > 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 > > > _______________________________________________ > Tutor maillist - Tutor@python.org > To unsubscribe or change subscription options: > https://mail.python.org/mailman/listinfo/tutor > _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor