Count number of columns and rows in an Excel file

February 19, 2019

Here's a quick demo on how to count the number of rows and columns in an Excel file using Python. 

 

First open the command prompt in the scripts folder for Python.  Enter this command to get the xlrd library:

pip install xlrd

 

 

We'll analyze this Excel file:

 

 

Import the xlrd module
>>> import xlrd

 

set the location of the file you want to analyze:
>>> loc = ("C:\FooFolder\Cities.xlsx")

 

identify it was as an Excel workbook
>>> wb = xlrd.open_workbook(loc)

 

select the sheet you want to review
>>> sheet = wb.sheet_by_index(0)

 

we can read a particular cell's value:
>>> sheet.cell_value(0,0)
'City'

 

Count the total number of rows:
>>> print(sheet.nrows)
7

 

. . . and the total number of columns:
>>> print(sheet.ncols)
1
>>> 

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com