python 用openpyxl打开exce表格并在指定单元格内读写

代码：

from openpyxl import load_workbook

def rw_excel():

    wb = load_workbook(r'D:\1.xlsx')    #加载workbook
    print(wb.sheetnames)    #查看都有哪些woeksheet
    ws = wb['Sheet1']   #选定一个worksheet
    ws.cell(row=1, column=5, value="11111111")  #第一种写入方法
    print(ws["E1"].value)   #把内容读取出来
    ws["E1"] = "22222222222"    #第二种写入方法
    print(ws["E1"].value)   #把内容读取出来
    wb.save(r'D:\1.xlsx')   #保存workbook
    wb.close()      #关闭workbook


rw_excel()

执行结果：

['Sheet1', 'Sheet2', 'Sheet3']
11111111
22222222222

Process finished with exit code 0