python学习笔记之openpyxl模块excel电子表格的读写

if __name__ == '__main__':
    from openpyxl import load_workbook  # 读取用
    from openpyxl import Workbook  # 写入的时候用
    ####################################read
    excel_p = r"D:pythonProjectsgq_selfword报告word转换表格.xlsx"
    wb = load_workbook(excel_p)
    sheets = wb.worksheets  # 获取当前所有的sheet
    print(sheets)
    # 获取第一张sheet
    sheet1 = sheets[0]
    print(sheet1)
    for i in range(11):
        cell_11 = sheet1.cell(1, 1 + i).value
        print(cell_11)
    wb.save('word报告word转换表格.xlsx')
    # 创建一个Workbook对象
    ####################################write
    big_ls = [[1.2, 3], [4, 5, 6], [7, 8, 9]]
    wb = Workbook()
    # 获取当前活跃的sheet，默认是第一个sheet
    ws = wb.active
    for i in big_ls: ws.append(i)
    wb.save('word报告word转换表格.xlsx')