Question

python 如何读取excel文件 将每一行存为数组

如下图，excel文件，没有表头名，我应该怎么读取这个文件，将每行数据存为数组，即 [(A,B),(A,C),(C,D),(E,F)]

Answer 1

from xlrd import open_workbook
wb=open_workbook(r'd:/222.xlsx')
tb=wb.sheets()[0]
data=[]
for r in range(tb.nrows):
val=[]
for c in range(tb.ncols):
val.append(tb.cell_value(r,c))
data.append(tuple(val))
print(data)

Answer 2

A1&B1不含括号