Python-包-python-openpyxl处理excel
workbook = openpyxl.load_workbook(‘test.xlsx’) # 返回一个workbook数据类型的值print(workbook.sheetnames) # 打印Excel表中的所有表
sheet = workbook[‘Sheet1’] # 获取指定shee
...