文件I/O-excel
读写数据
-
安装 openpyxl
pip install openpyxl
-
打开文件
from openpyxl import load_workbook from openpyxl.writer.excel import ExcelWriter try: workbook_ = load_workbook(u"data.xlsx") # 获得表单名字 sheetnames = workbook_.get_sheet_names() sheet = workbook_.get_sheet_by_name(sheetnames[0]) except Exception as ex: print(ex)
-
获取单元格
# 获取某个单元格的值,观察excel发现也是先字母再数字的顺序,即先列再行 b4 = sheet['A4'] #A行4列 # 除了用下标的方式获得,还可以用cell函数, 换成数字,这个表示B4 b4_too = sheet.cell(row=4, column=2) print(b4_too.value) for i in range(2): for j in range(5): print(sheet.cell(row=i+1, column=j+1).value,end=' ') print()
-
获得最大行和最大