【Python辦公自動化筆記-Excel篇5】存取區塊儲存格

from openpyxl import load_workbook
path = 'D:/sample.xlsx'
wb = load_workbook(path)
ws = wb['竹科1月']
cell_range = ws['C3:D6']

for row in cell_range:  # 預設以列為主拜訪
    print(row)

for row in cell_range:
    for cell in row:
        print(cell.value)

for col in ws.iter_cols\
            (min_row = 3, max_row = 6, min_col = 3, max_col = 4):
    for cell in col:
        print(cell.value)

for col in ws.columns:
    for cell in col:
        print(cell.value)

print(list(ws.values))

import openpyxl
print(openpyxl.utils.get_column_letter(2))          # 輸出 B
print(openpyxl.utils.column_index_from_string('Z')  # 輸出 26