Python Forum
object is not subscriptable... Error Message?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
object is not subscriptable... Error Message?
#3
thank you for the link. I have reviewed and am unable to find the details i am looking for. I am following an exercise in a book called Automate the boring stuff. i am following the exercise exactly and typing the following code
>>> import openpyxl
>>> wb=openpyxl.load_workbook('Example_Page267.xlsx')
>>> sheet=wb.active
>>> sheet.columns[1]

the output the book is saying i should get is
(<cell Sheet1.B1>,<cell Sheet1.B2>,<cell Sheet1.B3>,<cell Sheet1.B4>,<cell Sheet1.B5>,<cell Sheet1.B4>,<cell Sheet1.B5>,<cell Sheet1.B6>,<cell Sheet1.B7>)
but instead i am getting the error message
Traceback (most recent call last):
  File "<pyshell#160>", line 1, in <module>
    sheet.columns[1]
TypeError: 'generator' object is not subscriptable
could you give me an example of the code i should be inputting to get that output?
Reply


Messages In This Thread
RE: object is not subscriptable... Error Message? - by Shafla - Sep-24-2019, 08:22 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
Bug TypeError: 'NoneType' object is not subscriptable TheLummen 4 802 Nov-27-2023, 11:34 AM
Last Post: TheLummen
  Error message about iid from RandomizedSearchCV Visiting 2 1,058 Aug-17-2023, 07:53 PM
Last Post: Visiting
  Need help with 'str' object is not callable error. Fare 4 898 Jul-23-2023, 02:25 PM
Last Post: Fare
  Another Error message. the_jl_zone 2 1,012 Mar-06-2023, 10:23 PM
Last Post: the_jl_zone
  Help with python 'not subscriptable' error Extra 3 2,198 Dec-16-2022, 05:55 PM
Last Post: woooee
  TypeError: 'NoneType' object is not subscriptable syafiq14 3 5,333 Sep-19-2022, 02:43 PM
Last Post: Larz60+
  Error in Int object is not subscript-able. kakut 2 1,214 Jul-06-2022, 08:31 AM
Last Post: ibreeden
  Mysql error message: Lost connection to MySQL server during query tomtom 6 16,338 Feb-09-2022, 09:55 AM
Last Post: ibreeden
  understanding error message krlosbatist 1 1,943 Oct-24-2021, 08:34 PM
Last Post: Gribouillis
  'int' object is not subscriptable after API call ed8484 1 1,849 Sep-18-2021, 02:06 PM
Last Post: ed8484

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020