Python 读取excle文件所有内容[xlrd模块]

来源:互联网 发布:iphone mac 互传文件 编辑:程序博客网 时间:2024/06/11 05:18
from xlrd import open_workbookimport timestart = time.time()print u"正在打开Excel文件……"workbook = open_workbook('D:\\sst-DEMS_user.xls')print u"时间:", time.time() - startprint workbook.sheet_names()i = 0worksheets = workbook.sheet_names()for worksheet_name in worksheets:    worksheet = workbook.sheet_by_name(worksheet_name)    for rownum in range(worksheet.nrows):        info = [str(x) for x in worksheet.row_values(rownum)]        i += 1        print " ".join(info)print u"总记录:",i

0 0
原创粉丝点击