读取excel表格

import xlrd
workbook=xlrd.open_workbook(r'C:\Users\Administrator\Desktop\123.xls')
# print (workbook.sheet_names())
sheet1=workbook.sheet_by_name('Sheet1')#切换到sheet1
# print(type(sheet1.row_values(0)))#获取到第一行 获取的是list格式
rows_num = sheet1
# print(type(rows_num.nrows))
long=rows_num.nrows#获取到一共几行
for i in range(0,long):
    print('第'+str(i+1)+'行')
    print(int(sheet1.row_values(i)[0]))#  int是直接转换为整数型 i是第几行   【0】是第几列
    print(sheet1.row_values(i)[1])