1. ###循环插入多行数据
    2. from openpyxl import Workbook
    3. wb = Workbook()
    5. ws = wb.active
    7. #循环插入多行数据，此处的逗号是英文的
    8. data = [
    9.     ["fruit", 11, 12, 13, 14],
    10.     ['apple', 1, 2, 3, 4],
    11. ]
    12. for row in data:
    13.     ws.append(row)
    15. wb.save(r'C:\Users\wangjian\Desktop\test1.xls')