keyword = data.sheets()[0] ###获取源数据 nsheets = len(data.sheets()) ###获取表数量 nrows = keyword.nrows ###获取行数量 ###先复制源数据及模板 copy_sheet(keyword,result.add_sheet("目录")) copy_sheet(template,result.add_sheet("模板")) for i in range(1,nrows): row = keyword.row_values(i) num = row[0] ###获取编号EX:8. name = row[1] ###获取名称EX:百度 index = row[2] ###获取索引 url = "http://www." + index ###获取索引(必须加http否则出错) sheetname = str(int(num)) + "." + str(name)##EX:8.百度 try: newsheet = result.add_sheet(sheetname, cell_overwrite_ok=True) copy_sheet(template,newsheet) ###复制模板内容 city = NetFun.dm_server(index) ###查询数据并写入 newsheet.write(1,1,name) newsheet.write(1,3,url) newsheet.write(2,5,city) newsheet.write(4,1,reason + city + "。") ###准备截图并保存 picname = "1." + str(int(num)) + " " + str(name) + ".png" ##EX:1.8 百度.png NetFun.capture(url,picname) print(" " + str(i) + "/" + str(nrows-1) + " (" + name + "<>" + index + ") is finished." ) except Exception as e: print (e) print(" " + str(i) + "/" + str(nrows-1) + " (" + name + "<>" + index + ") is wrong." ) continue result.save(filename) print (" It's done! See you!")
keyword = data.sheets()[0] ###获取源数据 nrows = keyword.nrows ###获取行数量 ###先复制源数据及模板 copy_sheet(keyword,result.add_sheet("目录")) copy_sheet(template,result.add_sheet("模板")) newsheet = result.add_sheet("结果", cell_overwrite_ok=True) copy_sheet(template,newsheet) ###复制模板内容 for i in range(1,nrows): row = keyword.row_values(i) num = row[0] ###获取编号EX:8 name = row[1] ###获取名称EX:百度 url = row[2] ###获取网址EX:http://www.baidu.com sheetname = str(int(num)) + "." + str(name)##EX:8.百度 try: ###查询数据并写入(本示例为查询归属地 其他信息自行修改) city = NetFun.dm_server(url) newsheet.write(i,0,num) newsheet.write(i,1,name) newsheet.write(i,2,url) newsheet.write(i,3,city) ###准备截图并保存 picname = str(int(num)) + "." + str(name) + ".png" ##EX:8.百度.png NetFun.capture(url,picname) newsheet.write(i,4,"OK") print(" " + str(i) + "/" + str(nrows-1) + " ( " + name + "<>" + url + " ) is finished." ) except Exception as e: newsheet.write(i,4,"Wrong") print (e) print(" " + str(i) + "/" + str(nrows-1) + " ( " + name + "<>" + url + " ) is wrong." ) continue result.save(filename)
keyword = data.sheets()[0] ###获取源数据 nrows = keyword.nrows ###获取行数量 ###先复制源数据及模板 copy_sheet(keyword, result.add_sheet("目录")) copy_sheet(template, result.add_sheet("模板")) newsheet = result.add_sheet("结果", cell_overwrite_ok=True) copy_sheet(template, newsheet) ###复制模板内容 for i in range(1, nrows): row = keyword.row_values(i) num = row[0] ###获取编号EX:8 name = row[1] ###获取名称EX:百度 url = row[2] ###获取网址EX:http://www.baidu.com sheetname = str(int(num)) + "." + str(name) ##EX:8.百度 try: ###查询数据并写入(本示例为查询归属地 其他信息自行修改) city = NetFun.dm_server(url) newsheet.write(i, 0, num) newsheet.write(i, 1, name) newsheet.write(i, 2, url) newsheet.write(i, 3, city) ###准备截图并保存 picname = str(int(num)) + "." + str(name) + ".png" ##EX:8.百度.png NetFun.capture(url, picname) newsheet.write(i, 4, "OK") print(" " + str(i) + "/" + str(nrows - 1) + " ( " + name + "<>" + url + " ) is finished.") except Exception as e: newsheet.write(i, 4, "Wrong") print(e) print(" " + str(i) + "/" + str(nrows - 1) + " ( " + name + "<>" + url + " ) is wrong.")
nsheets = len(data.sheets()) ###获取表数量 nrows = keyword.nrows ###获取行数量 ###先复制源数据及模板 copy_sheet(keyword, result.add_sheet("目录")) copy_sheet(template, result.add_sheet("模板")) for i in range(1, nrows): row = keyword.row_values(i) num = row[0] ###获取编号EX:8. name = row[1] ###获取名称EX:百度 index = row[2] ###获取索引 url = "http://www." + index ###获取索引(必须加http否则出错) sheetname = str(int(num)) + "." + str(name) ##EX:8.百度 try: newsheet = result.add_sheet(sheetname, cell_overwrite_ok=True) copy_sheet(template, newsheet) ###复制模板内容 city = NetFun.dm_server(index) ###查询数据并写入 newsheet.write(1, 1, name) newsheet.write(1, 3, url) newsheet.write(2, 5, city) newsheet.write(4, 1, reason + city + "。") ###准备截图并保存 picname = "1." + str( int(num)) + " " + str(name) + ".png" ##EX:1.8 百度.png NetFun.capture(url, picname) print(" " + str(i) + "/" + str(nrows - 1) + " (" + name + "<>" + index + ") is finished.") except Exception as e: print(e) print(" " + str(i) + "/" + str(nrows - 1) + " (" + name + "<>" + index + ") is wrong.") continue