using openpyxl

[Pedroski55]

I am very interested in Python applied to spreadsheets, because I do simple, boring tasks with spreadsheets related to school and students. I got this code from Automate the Boring Stuff.

This must be a version problem I think. I looked at https://docs.python.org/3.5/
but I can't find the relevant documentation.

>>> wb = openpyxl.load_workbook('examples.xlsx')
>>> sheet = wb.get_sheet_by_name('Sheet1')
>>> sheet.get_highest_row()
Traceback (most recent call last):
  File "<pyshell#32>", line 1, in <module>
    sheet.get_highest_row()
AttributeError: 'Worksheet' object has no attribute 'get_highest_row'

Can someone please just point me at the right docs, I will read them!

[Larz60+]

please post enough code so that it can be run by moderators.
You can find the documentation here: https://openpyxl.readthedocs.io/en/default/

Thank you

[Pedroski55]

This is from the book, to be tried in the interactive shell. There is an excel file examples.xlsx in the cwd

>>> import openpyxl
>>> wb = openpyxl.load_workbook('example.xlsx')
>>> sheet = wb.get_sheet_by_name('Sheet1')
>>> sheet.get_highest_row()
7
>>> sheet.get_highest_column()
3
"Note that the get_highest_column() method returns an integer rather
than the letter that appears in Excel."

However, I just get an error.

[Larz60+]

Did you try to run interactively, or from a script?

[Pedroski55]

I did this in the interactive shell.

A bit further in the book I need sheet.get_highest_row() again, but I just get

Traceback (most recent call last):
File "<pyshell#48>", line 1, in <module>
sheet.get_highest_row()
AttributeError: 'Worksheet' object has no attribute 'get_highest_row'

#! python3
# readCensusExcel.py - Tabulates population and number of census tracts for
# each county.
u import openpyxl, pprint
print('Opening workbook...')
v wb = openpyxl.load_workbook('censuspopdata.xlsx')
w sheet = wb.get_sheet_by_name('Population by Census Tract')
countyData = {}
# TODO: Fill in countyData with each county's population and tracts.
print('Reading rows...')
x for row in range(2, sheet.get_highest_row() + 1):
# Each row in the spreadsheet has data for one census tract.
state = sheet['B' + str(row)].value
county = sheet['C' + str(row)].value
pop
= sheet['D' + str(row)].value
# TODO: Open a new text file and write the contents of countyData to it.

[Larz60+]

The errors above to not match the code you supplied
In addition, the error seems incomplete
without that we can be of little help

[Pedroski55]

Oh well, I'll get to the bottom of it eventually!

That is the entire error as it appears in the interactive shell:

>>> sheet.get_highest_row()
Traceback (most recent call last):
File "<pyshell#48>", line 1, in <module>
sheet.get_highest_row()
AttributeError: 'Worksheet' object has no attribute 'get_highest_row'
>>>

[Larz60+]

I think I'm looking at the Automate the Boring stuff page here: https://automatetheboringstuff.com/chapter12/
correct me if I'm wrong.
I'm going to do their tutorial and see if I can figure out what's going on.
I'll be back after that.

[Larz60+]

Ok,

Here's what I've done.

• I put the example into a script so that it would be easier to manipulate
  
• I downloaded the example file from: https://www.nostarch.com/download/Automa...erials.zip
  
• It works
  

Here's the code:

import openpyxl

wb = openpyxl.load_workbook('example.xlsx')
sheetnames = wb.get_sheet_names()
print('sheetnames: {}'.format(sheetnames))

sheet = wb.get_sheet_by_name('Sheet3')
print('sheet: {}'.format(sheet))
print('sheet data type: {}'.format(type(sheet)))

title = sheet.title
print('title: {}'.format(sheet.title))

anotherSheet = wb.active
print('anotherSheet: {}'.format(anotherSheet))

And the results:

Output:
sheetnames: ['Sheet1', 'Sheet2', 'Sheet3']
sheet: <Worksheet "Sheet3">
sheet data type: <class 'openpyxl.worksheet.worksheet.Worksheet'>
title: Sheet3
anotherSheet: <Worksheet "Sheet1">

I use python 3.6.2

[Pedroski55]

Thanks for going to all that trouble! The part you posted above works for me too, I use Ubuntu 16 and python 3.5

Did you try: sheet.get_highest_row() ??

I made my own spreadsheet, but that should not cause this error, it loads and reads ok. I can imagine situations where it is necessary to get the highest row and column before any manipulation with a 'for cell in range(1, highest_row)' loop, so there must be a routine to do that, I presume.