Change value in Excel using Python

In this article, We are going to change the value in an Excel Spreadsheet using Python.

Method 1: Using openxml:

openpyxl is a Python library to read/write Excel xlsx/xlsm/xltx/xltm files. It was born from a lack of an existing library to read/write natively from Python the Office Open XML format. openpyxl is the library needed for the following task. You can install openpyxl module by using the following command in Python.

pip install openpyxl

Function used:

• load_workbook(): function used to read the excel spreadsheet
• workbook.active: points towards the active sheet in the excel spreadsheet
• workbook.save(): saves the workbook

Approach:

1. Import openpyxl library
2. Start by opening the spreadsheet and selecting the main sheet
3. Write what you want into a specific cell
4. Save the spreadsheet

Excel File Used:

Below is the implementation:

Output:

Method 1: Using xlwt/xlrd/xlutils.

This package provides a collection of utilities for working with Excel files. Since these utilities may require either or both of the xlrd and xlwt packages, they are collected together here, separate from either package.You can install xlwt/xlrd/xlutils modules by using the following command in Python

pip install xlwt
pip install xlrd
pip install xlutils

Prerequisite:

• open_workbook(): function used to read the excel spreadsheet
• copy(): copies the content of a workbook
• get_sheet(): points towards a specific sheet in excel workbook
• write(): writes data in the file
• save(): saves the file

Approach:

1. Open Excel File
2. Make a writable copy of the opened Excel file
3. Read the first sheet to write within the writable copy
4. Modify value at the desired location
5. Save the workbook
6. Run the program

Excel File Used:

Below is the implementation:

Output:

After