import xlrd import urllib.request
nrows = 1# 读取多少行数据 data = xlrd.open_workbook('/home/xuliming/PycharmProjects/tensorflow_learning/data.xls') data_sheet = data.sheet_by_index(0) for i in range(nrows): url = data_sheet.cell(rowx=i,colx=0).value if url == '':# 如果某个单元为空,则结束当前循环 continue lable = data_sheet.cell(rowx=i,colx=1).value if lable == '': continue i_char = str(i) lable_char = str(lable) urllib.request.urlretrieve(url, '/home/xuliming/PycharmProjects/tensorflow_learning/data_self/' + i_char + '.' + lable_char + '.' + 'jpg')# 这里的路径只能使用字符型,所以先将两个参数转成字符格式