python办公自动化:多种方法获取excel单元格
import openpyxl# 打开excel表格workbook = openpyxl.load_workbook('xxxxxxx.xlsx')# 打印excel全部的sheet名称print(workbook.sheetnames)# 定位到单元表sheet = workbook['Sheet2']# 获取该单元表尺寸print(sheet.dimensions)# 获取单个单元格cell = sheet['F1']print(cell.value)print('.
原创
2022-03-11 17:11:24 ·
1927 阅读 ·
0 评论