Openpyxl Formulas
- In Openpyxl, We can write formula into the cell.
- These formulas are used to perform operations in excel file. After writing within the cell execute it from the workbook.
Openpyxl Formulas
Sample Code
from openpyxl import Workbook
wb = Workbook()
sheet = wb.active
rows_count = (
(14, 27),
(22, 30),
(42, 92),
(51, 32),
(16, 60),
(63, 13)
)
for i in rows_count:
sheet.append(i)
cell = sheet.cell(row=7, column=3)
cell.value = "=SUM(A1:B6)"
cell.font = cell.font.copy(bold=True)
wb.save('formulas_book.xlsx')
Output
