How to insert an array furmula in a cell?
Code:
#Insert Array Formula
from openpyxl import Workbook
from openpyxl.worksheet.formula import ArrayFormula
#Create a new workbook
wb=Workbook()
#Get the active worksheet
ws=wb.active
ws['C2']=1
ws['C3']=2
ws['C4']=3
ws['D2']=4
ws['D3']=5
ws['D4']=6
#Insert an array formula to sum products
ws['E2']=ArrayFormula('E2', '=SUM(C2:C4*D2:D4)')
wb.save('test.xlsx')
wb.close()
