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