python导入excel表格中的数据并生成矩阵

import numpy as np
import xlrd
read=xlrd.open_workbook('Z:\math\data.xlsx')

sheet1=read.sheet_by_index(0)

row=sheet1.nrows
col=sheet1.ncols

matrix=np.zeros((row,col))

for x in range(row):
    for y in range(col):
        matrix[x][y]=sheet1.cell_value(x,y)

print(matrix)

• xlrd版本号为1.2.0，新版本不支持xlsx