创建并修改excel，创建修改excel,[Python]代码#创

创建并修改excel，创建修改excel,[Python]代码#创

[Python]代码

#创建excel，并随机输入数据import xlwtimport xlrdimport randomfilename=xlwt.Workbook()sheet=filename.add_sheet("my_sheet")for row in range(0,10):    for col in range(0,10):        sheet.write(row,col,random.randrange(0,10))filename.save("D:/test.xls")print "Done"import xlrdfilename="D:/test.xls"data=xlrd.open_workbook(filename)sheet=data.sheet_by_index(0)rows=sheet.nrowscols=sheet.ncolsfor row in range(rows):    value=sheet.row_values(row)    print valueimport timetime.sleep(20)#判断每行的和，若>=40,则为“ok"，否则为”no“from xlrd import open_workbookfrom xlutils.copy import copyrb=open_workbook("D:test.xls")sheet=rb.sheet_by_index(0)rows=sheet.nrowscols=sheet.ncolswb=copy(rb)ws=wb.get_sheet(0)for row in range(rows):    value=sheet.row_values(row)    if sum(value)>=40:        ws.write(row,10,"ok")    else:        ws.write(row,10,"no")wb.save("D:/test.xls")