实战小项目：爬取教务网成绩并存入excel

#获取基本信息 detailURL='http://zhjw.scu.edu.cn/gradeLnAllAction.do?type=ln&oper=qbinfo&lnxndm=2016-2017%D1%A7%C4%EA%C7%EF(%C1%BD%D1%A7%C6%DA)' html=s.get(url=detailURL) main=html.content.decode('gbk') soup=BeautifulSoup(main,'lxml') content=soup.find_all('td',align="center") #将信息放入一个list中,创建new_list(方便后续存入excel) data_list=[] for data in content: data_list.append(data.text.strip()) new_list=[data_list[i:i+7] for i in range(0,len(data_list),7)] #数据存入excel表格 book=xlwt.Workbook() sheet1=book.add_shee