How To Insert a Formula Using OpenPyXL?

Method

>>>sht[“C1”]=1

>>>sht[“C2”]=2

>>>sht[“C3″]=”=SUM(C1:C2)”

Sample 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()