작성
| 명칭 | ||
|---|---|---|
| Workbook | ||
| Worksheet | ||
| Active Worksheet | ||
| Row | ||
| Columns | ||
| Cell |
샘플
작성하기
import openpyxl as excel book = excel.Workbook() sheet = book.active sheet['A11'] = 'ABC' book.save('hello.xlsx') |
불러오기
import openpyxl as excel book = excel.load_workbook('hello.xlsx') sheet = book.worksheets[0] cell = sheet["A11"] print(cell.value) |
|
ABC |
