首页 > 代码库 > xlrd读取多个excel电子表数据
xlrd读取多个excel电子表数据
import sys import xlrd import traceback def ReadData(FileName): try: workBook = xlrd.open_workbook(FileName) sheetsList = workBook.sheet_names() sheetNum = len(sheetsList) for i in range(sheetNum): readName = sheetsList[i] #para = [‘sheet%s‘ %i] sheet = workBook.sheet_by_index(i) print(readName+‘:\n‘) for i in range(sheet.nrows): rows = sheet.row_values(i) print(rows) except: traceback.print_exc() if __name__ == ‘__main__‘ : ReadData(‘demo1.xlsx‘)
xlrd读取多个excel电子表数据
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。