excel常用操作(一)---获取行数(python2.7)侵删
import xlrd
xlrd.Book.encoding = "utf-8"
data=xlrd.open_workbook("E:/读取行数.xls")
table=data.sheets()[0]
nrows=table.nrows
print(nrows)
import xlrd
xlrd.Book.encoding = "utf-8"
data=xlrd.open_workbook("E:/读取行数.xls")
table=data.sheets()[0]
nrows=table.nrows
print(nrows)