반응형
'''
수식 - 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')
반응형
'Python_Intermediate > Openpyxl' 카테고리의 다른 글
| Python Openpyxl - Excel to TXT (0) | 2019.08.09 |
|---|---|
| Python Openpyxl - Merged (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 |
