Get values of all rows in a particular column in openpyxl in Python

In this openpyxl tutorial, we will learn how we can get values of all rows in a particular column using openpyxl library in Python.

Program to get values of all rows in a particular column using openpyxl

Here, in this program, we will use the openpyxl library to do the operation which contains various modules for creating, modifying, and reading Excel files.

Let’s take a sample Excel workbook with some value in it for the program.

Our aim is to display the values of all the rows of a particular column of the active sheet.

Step1: Firstly, let’s import openpyxl library to our program.

import openpyxl

Step2: Load the Excel workbook to the program by specifying the file’s path. Here, we will use the load_workbook() method of the openpyxl library for this operation.

wb = openpyxl.load_workbook("//home//sanamsahoo0876//Documents//Book1.xlsx")

Step3: Create a variable and assign it with the active sheet’s reference by giving the sheet’s name.

sh = wb["Sheet1"]

Step4: Iterate through cells of a column which values are to be printed on the console. Here we have taken the first column ‘A‘ to get all the values of the rows of this column.

for col in sh['A']:
   print(col.value)

Here is the complete Python Program:

import openpyxl

wb = openpyxl.load_workbook("//home//sanamsahoo0876//Documents//Book1.xlsx")
sh = wb["Sheet1"]

for col in sh['A']:
   print(col.value)

Output:

Student_ID
1901568086
1901568087
1901568088
1901568089
1901568090
1901568091

We have successfully got all the values of the row of the particular column.

I hope you have enjoyed reading this article and learned how we can get the values of all rows of a column using openpyxl in Python.

You can also read, How to read cell value in openpyxl in Python