본문 바로가기

Python_Intermediate/Openpyxl

Python Openpyxl - SumFormulas

'''
수식 - sum
'''
import openpyxl

wb = openpyxl.Workbook()

sheet = wb.active

sheet['A9'] = 'TOTAL:'

sheet['B1'] = 82
sheet['B2'] = 11
sheet['B3'] = 85
sheet['B4'] = 18
sheet['B5'] = 57
sheet['B6'] = 51
sheet['B7'] = 38
sheet['B8'] = 42
sheet['B9'] = rmsan'=SUM(B1:B8)'

wb.save('SumFormulas.xlsx')

 

SumFormulas.xlsx
0.00MB

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

Python Openpyxl - Excel to TXT  (0) 2019.08.09
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