python 图片保存到本地

from xlrd import open_workbook
import requests
import os

def conn():
    workbook = open_workbook(r'C:\路径\inquiry_info.xls')
    sheet = workbook.sheet_by_index(0)
    for i in range(1, 394):
        company_name = sheet.cell(i, 7).value
        logo = sheet.cell(i, 22).value
        args = (logo,company_name)
        print(args)
        if logo == '无' or logo == '':
            pass
        else:
            # 下载到本地
            print(args)
            url = logo
            d = 'D:\\B\\'
            path = d + str(company_name) + '.' + url.split('.')[-1]
            try:
                if not os.path.exists(d):
                    os.mkdir(d)
                if not os.path.exists(path):
                    r = requests.get(url)
                    r.raise_for_status()
                    with open(path, 'wb') as f:
                        f.write(r.content)
                        f.close()
                        print("图片保存成功")
                else:
                    print("图片已存在")
            except:
                print("图片获取失败")
conn()