반응형
'''
수식 - sum
'''
import openpyxl
wb = openpyxl.Workbook()
sheet = wb.active
sheet['A1'] = 200
sheet['A2'] = 300
sheet['A3'] = '=SUM(A1:A2)'
wb.save('writeFormula.xlsx')
반응형
'Python_Intermediate > Openpyxl' 카테고리의 다른 글
Python Openpyxl - Merged (0) | 2019.08.09 |
---|---|
Python Openpyxl - SumFormulas (0) | 2019.08.09 |
Python Openpyxl - New File SAVE (0) | 2019.08.09 |
Python Openpyxl - Basic (0) | 2019.08.09 |
Python Openpyxl - Sheet Delete(excel file) (0) | 2019.04.27 |