top of page

Count number of columns and rows in an Excel file

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 >>>

bottom of page