摘要: from openpyxl import load_workbookwb = load_workbook("files/p1.xlsx")sheet = wb.worksheets[0]# 获取第几行第几列cell = sheet.cell(1,1)# 获取值print(cell.value)# 获 阅读全文
posted @ 2020-12-29 22:23 干it的小张 阅读(111) 评论(0) 推荐(0) 编辑
摘要: p1.xlsx 数据导出页: 用户列表页: sheet1: sheet2: from openpyxl import load_workbookwb = load_workbook("files/p1.xlsx")# 获取所有sheet名称print(wb.sheetnames)# 读取第一行第一列 阅读全文
posted @ 2020-12-29 22:02 干it的小张 阅读(164) 评论(0) 推荐(0) 编辑