How To Reference Single or Multiple Rows/Columns Using OpenPyXL?

Method

Reference rows or columns by their index or column letter.

 

Reference a single row/column

Reference continuous multiple rows/columns

Sample Code

#Accessing Specific Rows and Columns

#Import load_workbook function
from openpyxl import Workbook

#Create a new workbook
wb=Workbook()
#Get the active worksheet
ws=wb.active

#Get the 10th row
row10=ws[10]
#Get the 3rd column
colC=ws['C']

#Get multiple rows
rows1=ws[5:10]
#Get multiple columns
cols1=ws['C:D']

wb.save('test.xlsx')
wb.close()