Python Write Excel xlsx File with Formula Cells using OpenPyXL
In this Python openpyxl tutorial we learn how to write Excel xlsx files with formula cells using the openpyxl package.
How to install the openpyxl package
To install the openpyxl package using the command below.
pip install openpyxl
Step by step to write Excel xlsx file with formula
Import the Workbook from the openpyxl package.
from openpyxl import Workbook
Create a new Workbook object.
workbook = Workbook()
Get the default Worksheet object.
worksheet = workbook.active
Assign values for cell A1, A2, A3.
worksheet['A1'] = 10 worksheet['A2'] = 5 worksheet['A3'] = 7
Assign formula to cell A4 as sum values from A1 to A3.
worksheet['A4'] = '=SUM(A1:A3)'
Save the Workbook as formula.xlsx file.
The complete Python program as below.
from openpyxl import Workbook workbook = Workbook() worksheet = workbook.active worksheet['A1'] = 10 worksheet['A2'] = 5 worksheet['A3'] = 7 worksheet['A4'] = '=SUM(A1:A3)' workbook.save('formula.xlsx')
Execute the above Python program we will get the Excel file formula.xlsx as below screenshot.
Happy Coding 😊