python读取excel表格
# -*- coding:utf-8 -*- import xlrd path = u"C:\\读取表格\\表格.xls"# workbook = xlrd.open_workbook(path) sheet = workbook.sheet_by_index(0) for row in range(sheet.nrows): for col in range(sheet.ncols): print(sheet.row(row)[col].value)#按行读取excel