[已解决]求助关于将数值写入excel问题

xue11

例如：numbers= [20,300,20190501,1523456790]
想将该列表中的每一个值写入excel中，并这样呈现，可见截图，想利用openpyxl库实现，请问有什么方法没？感谢

最佳答案

月排行榜 / 总排行榜

wp231957

2019-5-1 09:08:47

1. # coding: utf-8
   
2. import xlwt
   
3. 
   
4. 
   
5. xlsfile=xlwt.Workbook(encoding = 'utf-8')
   
6. worksheet=xlsfile.add_sheet('My Worksheet')
   
7. numbers= [20,300,20190501,1523456790]
   
8. col=0
   
9. for x in  numbers:
   
10.     worksheet.write(col,0, label = x)
    
11.     col+=1
    
12. xlsfile.save("ttt.xls")

复制代码

跳转到最佳答案楼层

wp231957

1. # coding: utf-8
   
2. import xlwt
   
3. 
   
4. 
   
5. xlsfile=xlwt.Workbook(encoding = 'utf-8')
   
6. worksheet=xlsfile.add_sheet('My Worksheet')
   
7. numbers= [20,300,20190501,1523456790]
   
8. col=0
   
9. for x in  numbers:
   
10.     worksheet.write(col,0, label = x)
    
11.     col+=1
    
12. xlsfile.save("ttt.xls")

复制代码

wrpython

学习一下， 正好在搞这个~

jiajiayao

1. import bs4,requests
   
2. import openpyxl
   
3. url="https://www.bilibili.com/ranking"
   
4. res=requests.get(url)
   
5. res.encoding='utf-8'
   
6. soup=bs4.BeautifulSoup(res.text,"html.parser")
   
7. 
   
8. #print(soup.text)
   
9. targets=soup.find_all(class_="rank-item")
   
10. wb=openpyxl.Workbook()
    
11. ws=wb.worksheets[0]
    
12. #print(targets)
    
13. lin =["排序","作品名称","播放量","up主"]
    
14. ws.append(lin)
    
15. for each in targets:
    
16.     num=each.find(class_="num").text
    
17.     print(num)
    
18.     print("稿件名称：")
    
19.     name=each.findAll("a")[1].text
    
20.     print(name)
    
21.     times=each.findAll('span')[0].text
    
22.     print(times)
    
23.     print("up主：")
    
24.     up=each.findAll('span')[2].text
    
25.     print(up)
    
26.     line=[num,name,times,up]
    
27.     ws.append(line)
    
28.     wb.save('234.xls')
    

复制代码