因为刚学python不久,又急着用,所以就编了个简陋版的
# -*- coding: utf8-*-
#安装openpyxl,没安装的可以在桌面打开cmd,输入下面代码(使用阿里云镜像下载,下载速度快):
#pip install openpyxl -i http://mirrors.aliyun.com/pypi/simple/
from openpyxl import load_workbook, Workbook
wb = Workbook()
#获取表格数据
#这里是需要读取excel的文件名(注意一定要跟代码放在同一个根目录下,因为代码极其简陋)
wb2 = load_workbook('科博桐乡专卖店.xlsx')
# print(wb2.sheetnames)
ws = wb2['sheet1']
# print(ws)
# colD2 = ws['D2:D60']
# print(colD2)
# 获取详情页地址
sublist = []
pic = []
def detail