from xlutils.copy import copy
import xlrd
import json
#在函数中参数化sheet名,行,列作为缺省参数写死
def excel_data(sheetNo,Numrow,row=1,col=2):
excelDir = "../Data/dada_data.xlsx"
#读表格中的数据
workname = xlrd.open_workbook(excelDir)
#que=workname.sheet_names()
#print(que)
worksheet =workname.sheet_by_index(sheetNo)
#写入表格操作,copy出来新的表跟sheet,并返回
newworkbook = copy(workname)
newsheet = newworkbook.get_sheet(0)
return worksheet.cell(Numrow,row).value,worksheet.cell(Numrow,col).value,newworkbook,newsheet
bodydata =excel_data(0,1)
print(bodydata)
for one in range(2,44):
print(excel_data(0,one))
#写入表格,3好像是固定的,也不太理解3的意思,22是第22列,后面再跟要写的内容
bodydata[3].write(one,22,"通过")
#最后保存+保存路径,新名字
bodydata[2].save("./resq.xls")