仅作参考
修改: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