Read excel file python openpyxl

View Discussion

Improve Article

Save Article

View Discussion

Improve Article

Save Article

Openpyxl is a Python library for reading and writing Excel (with extension xlsx/xlsm/xltx/xltm) files. The openpyxl module allows Python program to read and modify Excel files.
For example, users might have to go through thousands of rows and pick out a few handful of information to make small changes based on some criteria. Using Openpyxl module, these tasks can be done very efficiently and easily.
Use this command to install openpyxl module : 
 

sudo pip3 install openpyxl 

 
Input file : 
 

Code #1 : Program to print the particular cell value 
 

Python3

import openpyxl

path = "C:\\Users\\Admin\\Desktop\\demo.xlsx"

wb_obj = openpyxl.load_workbook(path)

sheet_obj = wb_obj.active

cell_obj = sheet_obj.cell(row = 1, column = 1)

print(cell_obj.value)

Output : 
 

STUDENT 'S NAME

  
Code #2 : Determine total number of rows 
 

Python3

import openpyxl

path = "C:\\Users\\Admin\\Desktop\\demo.xlsx"

wb_obj = openpyxl.load_workbook(path)

sheet_obj = wb_obj.active

print(sheet_obj.max_row)

Output : 
 

6

  
Code #3 : Determine total number of columns 
 

Python3

import openpyxl

path = "C:\\Users\\Admin\\Desktop\\demo.xlsx"

wb_obj = openpyxl.load_workbook(path)

sheet_obj = wb_obj.active

print(sheet_obj.max_column)

Output : 
 

4

  
Code #4 : Print all columns name 
 

Python3

import openpyxl

path = "C:\\Users\\Admin\\Desktop\\demo.xlsx"

wb_obj = openpyxl.load_workbook(path)

sheet_obj = wb_obj.active

max_col = sheet_obj.max_column

for i in range(1, max_col + 1):

    cell_obj = sheet_obj.cell(row = 1, column = i)

    print(cell_obj.value)

Output : 
 

STUDENT 'S NAME
COURSE
BRANCH
SEMESTER

  
Code #5 : Print first column value 
 

Python3

import openpyxl

path = "C:\\Users\\Admin\\Desktop\\demo.xlsx"

wb_obj = openpyxl.load_workbook(path)

sheet_obj = wb_obj.active

m_row = sheet_obj.max_row

for i in range(1, m_row + 1):

    cell_obj = sheet_obj.cell(row = i, column = 1)

    print(cell_obj.value)

Output : 
 

STUDENT 'S NAME
ANKIT RAI
RAHUL RAI
PRIYA RAI
AISHWARYA
HARSHITA JAISWAL

  
Code #6 : Print a particular row value 
 

Python3

import openpyxl

path = "C:\\Users\\Admin\\Desktop\\demo.xlsx"

wb_obj = openpyxl.load_workbook(path)

sheet_obj = wb_obj.active

max_col = sheet_obj.max_column

for i in range(1, max_col + 1):

    cell_obj = sheet_obj.cell(row = 2, column = i)

    print(cell_obj.value, end = " ")

Output : 
 

ANKIT RAI B.TECH CSE 4