1.xlsx的內容花颗，Python實現excel轉成列表
| A11 | B1 | C61 |
|---|---|---|
| A12 | B2 | C62 |
| A13 | B3 | C63 |
| A14 | B4 | C64 |
from openpyxl import load_workbook
#實現excel轉成二維列表
def excel_to_lists(filename,sheetname):
wb = load_workbook(filename)
ws = wb[sheetname]
# 讀取數據稽莉，比如把excel中的一個table按行讀取出來坝茎，存入一個二維的list
total_list = []
for row in ws.rows:
row_list = []
for cell in row:
row_list.append(cell.value)
total_list.append(row_list)
return total_list
list1=excel_to_lists('1.xlsx','Sheet1')
#通過遍歷列表獲取值
for i in list1:
print(i[0])
