python读取excel

import openpyxl
wb = openpyxl.load_workbook('example.xlsx')
# 从工作薄中获取一个表单(sheet)对象
sheets = wb.sheetnames
print(sheets, type(sheets))
ws = wb.get_sheet_by_name('Sheet3')
lng = ws.cell(i,3).value#获取i行3列的表格值

ws.max_row和ws.max_column给出数据用到的最大行和列

参考
https://www.cnblogs.com/crazymagic/articles/9752287.html
https://www.cnblogs.com/shaosks/p/6098282.html