Count the Number of Sheets, Rows, Columns and Cells in Excel in Python

4 min readJul 25, 2023

Counting the number sheets, rows, columns, and cells in Excel is a valuable skill that equips you with crucial insights into the structure and scale of your data. By accurately quantifying these metrics, you gain a comprehensive understanding of the dataset’s dimensions, which facilitates effective data management, analysis, and decision-making. In this article, we will explore how to count the number of sheets, used rows, columns and cells in Excel using Python.

Count the Number of Sheets in an Excel File in Python
Count the Number of Used Rows in an Excel Sheet in Python
Count the Number of Used Columns in an Excel Sheet in Python
Count the Number of Used Cells in an Excel Sheet in Python

Installation

To count the number of sheets, rows, columns and cells in Excel, we will use Spire.XLS for Python, which is a Python Excel library for creating, reading, editing, and converting Excel files within Python applications.

You can install Spire.XLS for Python from pypi by running the following commands in your terminal:

pip install Spire.Xls

For more detailed information about the installation, you can check this official documentation: How to Install Spire.XLS for Python in VS Code.

Count the Number of Sheets in an Excel File in Python

To get the number of sheets in an Excel file, you can use the Workbook.Worksheets.Count property provided by Spire.XLS for Python.

Here is a simple example that shows how to get the number of sheets in an Excel file in Python:

from spire.xls import *
from spire.xls.common import *

# Initialize an instance of the Workbook class
workbook = Workbook()
# Load an Excel file
workbook.LoadFromFile("Sample.xlsx")

# Get the number of sheets in the file
sheetCount = workbook.Worksheets.Count
print(sheetCount)

workbook.Dispose()

Count the Number of Sheets in Excel in Python

Count the Number of Used Rows in an Excel Sheet in Python

To get the number of used rows in an Excel sheet, you can use the Worksheet.Rows.Length property provided by Spire.XLS for Python.

Here is a simple example that shows how to get the number of used rows in an Excel sheet in Python:

from spire.xls import *
from spire.xls.common import *

# Initialize an instance of the Workbook class
workbook = Workbook()
# Load an Excel file
workbook.LoadFromFile("Sample.xlsx")

# Get the first sheet by its index
sheet = workbook.Worksheets[0]

# Get the number of used rows in the sheet
rowCount = sheet.Rows.Length
print(rowCount)

workbook.Dispose()

Count the Number of Used Rows in an Excel Sheet in Python

Count the Number of Used Columns in an Excel Sheet in Python

To get the number of used columns in an Excel sheet, you can use the Worksheet.Columns.Length property provided by Spire.XLS for Python.

Here is a simple example that shows how to get the number of used columns in an Excel sheet in Python:

from spire.xls import *
from spire.xls.common import *

# Initialize an instance of the Workbook class
workbook = Workbook()
# Load an Excel file
workbook.LoadFromFile("Sample.xlsx")

# Get the first sheet by its index
sheet = workbook.Worksheets[0]

# Get the number of used columns in the sheet
columnCount = sheet.Columns.Length
print(columnCount)

workbook.Dispose()

Count the Number of Used Columns in an Excel Sheet in Python

Count the Number of Used Cells in an Excel Sheet in Python

To get the number of used cells in an Excel sheet, you can use the Worksheet.Cells.Length property provided by Spire.XLS for Python.

Here is a simple example that shows how to get the number of used cells in an Excel sheet in Python:

from spire.xls import *
from spire.xls.common import *

# Initialize an instance of the Workbook class
workbook = Workbook()
# Load an Excel file
workbook.LoadFromFile("Sample.xlsx")

# Get the first sheet by its index
sheet = workbook.Worksheets[0]

# Get the number of used cells in the sheet
cellCount = sheet.Cells.Length
print(cellCount)

workbook.Dispose()