for i in range(1, len(persionlist) 1, 1):
worksheet.write(i, 0, persionlist[i - 1][ num ])
worksheet.write(i, 1, persionlist[i - 1][ name ])
worksheet.write(i, 2, persionlist[i - 1][ money ])
worksheet.write(i, 3, persionlist[i - 1][ company ])
worksheet.write(i, 4, persionlist[i - 1][ country ])
workbook.save(path)
print( 数据保存成功 path)
if __name__ __main__ :
## 爬取数据
data loadalldata()
## 保存数据
savedata( rank.xls , data) # py文件同级目录创建rank.xls文件
