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
