# coding:utf-8
from bs4 import BeautifulSoup
import xlwings as xw

wb_data = ''
soup = BeautifulSoup(wb_data, 'lxml')


Title = soup.select('p.name')
titles = soup.select('p.title')

aa = soup.select('span.col.num.custom.col-0')
bb = soup.select('span.col.num.custom.col-1')
cc = soup.select('span.col.num.custom.col-2')
dd = soup.select('span.col.num.custom.col-3')
ee = soup.select('span.col.num.custom.col-4')
# for i in range(len(aa)):
#     print(aa[i].get_text())
# for i in range(len(bb)):
#     print(bb[i].get_text())
# for i in range(len(cc)):
#     print(cc[i].get_text())
# for i in range(len(dd)):
#     print(dd[i].get_text())
# for i in range(len(ee)):
#     print(ee[i].get_text())


def Initinal():
    app = xw.App(visible=False, add_book=True)
    wb = app.books.add()
    wb.sheets['sheet1'].range('A1').value = Title[0].get_text()
    wb.sheets['sheet1'].range('B1').value = Title[1].get_text()
    wb.sheets['sheet1'].range('C1').value = Title[2].get_text()
    wb.sheets['sheet1'].range('D1').value = Title[3].get_text()
    wb.sheets['sheet1'].range('E1').value = Title[4].get_text()
    path = r'e:\STT327.xlsx'
    wb.save(path)
    wb.close()
    app.quit()

Initinal()