import requests;
import xlrd;
excel_data = xlrd.open_workbook('img_url.xls');
table = excel_data.sheets()[0];
nrows = table.nrows;
i=0;
while i<nrows:
print i;
cell_Ai = table.cell(i,0).value;
cell_Bi = table.cell(i,1).value;
url = "http://eadmins.xiaoxi6.com/"+cell_Ai;
session = requests.session();
resp = session.get(url);
if resp.status_code == 404:
print url+" not found";
url = "http://eadmins.xiaoxi6.com/" + cell_Bi;
resp = session.get(url);
if resp.status_code == 404:
print url + " not found";
i = i+1;
2.测试数据
/upload/old_goods_img/201612/thumb_img/45380_thumb_G_1482778712042.jpg | /upload/old_goods_img/201612/source_img/45380_G_1482778712529.jpg |
/upload/old_goods_img/201612/thumb_img/45351_thumb_G_1482705444363.jpg | /upload/old_goods_img/201612/source_img/45351_G_1482705444473.png |
/upload/old_goods_img/201612/thumb_img/45325_thumb_G_1482536460716.jpg | /upload/old_goods_img/201612/source_img/45325_G_1482536460417.jpg |
/upload/old_goods_img/201612/thumb_img/45299_thumb_G_1482373728832.jpg | /upload/old_goods_img/201612/source_img/45299_G_1482373728254.jpg |
/upload/old_goods_img/201612/thumb_img/45296_thumb_G_1482362585652.jpg | /upload/old_goods_img/201612/source_img/45296_G_1482362585707.jpg |
/upload/old_goods_img/201612/thumb_img/45295_thumb_G_1482362049477.jpg | /upload/old_goods_img/201612/source_img/45295_G_1482362049852.jpg |
/upload/old_goods_img/201612/thumb_img/45294_thumb_G_1482361774835.jpg | /upload/old_goods_img/201612/source_img/45294_G_1482361774772.jpg |
/upload/old_goods_img/201612/thumb_img/45293_thumb_G_1482361396435.jpg | /upload/old_goods_img/201612/source_img/45293_G_1482361396102.png |
/upload/old_goods_img/201612/thumb_img/45292_thumb_G_1482361005500.jpg | /upload/old_goods_img/201612/source_img/45292_G_1482361005848.jpg |
/upload/old_goods_img/201612/thumb_img/45292_thumb_G_1482361005500.jpg | /upload/old_goods_img/201612/source_img/45292_G_1482361005848.jpg |
/upload/old_goods_img/201612/thumb_img/45291_thumb_G_1482360527593.jpg | /upload/old_goods_img/201612/source_img/45291_G_1482360527704.jpg |
/upload/old_goods_img/201612/thumb_img/45290_thumb_G_1482359891562.jpg | /upload/old_goods_img/201612/source_img/45290_G_1482359891845.jpg |
/upload/old_goods_img/201612/thumb_img/45290_thumb_G_1482359891562.jpg | /upload/old_goods_img/201612/source_img/45290_G_1482359891845.jpg |