【Python辦公自動化筆記-Excel篇6】讀取資料

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

max_row_number = ws.max_row     # 其實也就是工作表的列數
max_col_number = ws.max_column  # 其實也就是工作表的行數

B1_row_number = ws['B1'].row     # B1所在的列號 == 1
B1_col_column = ws['B1'].column  # B1所在的行號 == 2

# 讀取第1列的所有資料
data1 = []
for cell in ws[1]:
    data1.append(cell.value)
print(data1)

# 讀取B行所有資料
data2 = []
for cell in ws['B']:
    data2.append(cell.value)
print(data2)

# 讀取工作表所有資料
data3 = []
for row in ws.rows:
    for cell in row:
        data3.append(cell.value)
print(data3)

wb.save(path)