python中对excel表格数据的修改，插入，删除，获取

仅作参考

修改：xlrd库与xlutils库结合

import xlrd
from xlutils.copy import copy
def oop1():
    work = xlrd.open_workbook("ceshishujvku.xlsx")
    old_cibtent=copy(work)
    ws=old_cibtent.get_sheet(0)
    ws.write(2,1,'jimclear')#第2列第1行
    old_cibtent.save("jim.xlsx")




if __name__ == '__main__':
    oop1()

 openpyxl库

import openpyxl
def oop2():
    wb=openpyxl.load_workbook("ceshishujvku.xlsx")
    sheet=wb.worksheets[0]
    sheet.cell(2,1).value="jimlucky"#第2行第1列
    wb.save("jimlucky.xlsx")

if __name__ == '__main__':
    oop2()

 插入：openpyxl库

def oop3():
    wb = openpyxl.Workbook()
    ws = wb.create_sheet("sheet1")
    for i in range(1, 100):
        ws.cell(row=i, column=1).value = "jim{}".format(i)#row行，column列
        wb.save("jim01.xlsx")


if __name__ == '__main__':
    oop3()