본문 바로가기

Python_Intermediate/Openpyxl

Python Openpyxl - WriteFormula

'''
수식 - 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

'Python_Intermediate > Openpyxl' 카테고리의 다른 글

Python Openpyxl - Merged  (0) 2019.08.09
Python Openpyxl - SumFormulas  (0) 2019.08.09
Python Openpyxl - WriteFormula  (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