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
  I am getting this TypeError: 'TreasureMap' object is not subscriptable. makilakos 2 251 May-25-2024, 07:58 PM
Last Post: deanhystad
Bug TypeError: 'NoneType' object is not subscriptable TheLummen 4 904 Nov-27-2023, 11:34 AM
Last Post: TheLummen
  Error message about iid from RandomizedSearchCV Visiting 2 1,118 Aug-17-2023, 07:53 PM
Last Post: Visiting
  Need help with 'str' object is not callable error. Fare 4 968 Jul-23-2023, 02:25 PM
Last Post: Fare
  Another Error message. the_jl_zone 2 1,040 Mar-06-2023, 10:23 PM
Last Post: the_jl_zone
  Help with python 'not subscriptable' error Extra 3 2,335 Dec-16-2022, 05:55 PM
Last Post: woooee
  TypeError: 'NoneType' object is not subscriptable syafiq14 3 5,409 Sep-19-2022, 02:43 PM
Last Post: Larz60+
  Error in Int object is not subscript-able. kakut 2 1,244 Jul-06-2022, 08:31 AM
Last Post: ibreeden
  Mysql error message: Lost connection to MySQL server during query tomtom 6 16,609 Feb-09-2022, 09:55 AM
Last Post: ibreeden
  understanding error message krlosbatist 1 1,968 Oct-24-2021, 08:34 PM
Last Post: Gribouillis

Forum Jump:

User Panel Messages

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