Excel读写测试数据 # 只支持这种后缀 .xlsx -->openpyxl 只支持这种格式 from openpyxl import load_workbook # 1.打开Excel wb = load_workbook("./class_excel/test.xlsx") # Open the given filename and return the workbook # 2.定位表单 sheet = wb['python']