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