Python_Intermediate/Openpyxl

Python Openpyxl - WriteFormula

AnKiWoong 2019. 8. 9. 10:24
반응형
'''
수식 - sum
'''
import openpyxl
wb = openpyxl.Workbook()

sheet = wb.active
sheet['A1'] = 200
sheet['A2'] = 300
sheet['A3'] = '=SUM(A1:A2)'

wb.save('writeFormula.xlsx')

 

writeFormula.xlsx
0.00MB

반응형