How to insert a furmula in a cell?
Code:
#Insert Regular Formula
from openpyxl import Workbook
#Create a new workbook
wb=Workbook()
#Get the active worksheet
ws=wb.active
#Assign values to cells C1 and C2
ws['C1']=10
ws['C2']=20
#Insert a formula to sum values
ws['C3']='=SUM(C1:C2)'
wb.save('test.xlsx')
wb.close()