openpyxl

Python openpyxl 读取Excel excel_path = os.getcwd() + '/resources/v6.xlsx' ws = openpyxl.load_workbook(excel_path) sheetnames = ws.sheetnames读取第一个Sheet内容，从第2行开始读，读到100行： sheet = ws[sheet