【Python辦公自動化筆記-Excel篇4】存取單一儲存格

from openpyxl import load_workbook

path = 'D:/sample.xlsx'
wb = load_workbook(path)
ws = wb['竹科2月']

# 以下d是儲存格物件變數，data是數值變數
ws['A4'] = 3  # 把3存入A4儲存格
d = ws['A4']  # 把A4儲存格物件指定給變數d
print(f'd = {d}')  # 輸出 d = <Cell '竹科2月'.A4>
print(f'd.value = {d.value}')  # 輸出 d.value = 3

data = ws['A4'].value  # 把A4儲存格的值指定給變數data
print(f'data = {data}')  # 輸出 data = 3

d = ws.cell(row = 4, column = 1, value = 10)  
也可以用cell()方法直接賦值給儲存格
print(f'd.value = {d.value}')  # 輸出 d.value = 10

d = ws.cell(4, 1, value = 5)  
# cell()方法的第1個參數是列號，第2個參數是行號
print(f'd.value = {d.value}')  # 輸出 d.value = 5

wb.save(path)