想用xlsxwriter把数据存进xls表格

小小鹏

1. import re,requests
   
2. import time,json
   
3. from pyquery import PyQuery as pq
   
4. import xlsxwriter
   
5. from snownlp import SnowNLP
   
6. 
   
7. mybook = xlsxwriter.Workbook("1.xls")#建立文件
   
8. worksheet = mybook.add_worksheet()
   
9. 
   
10. headers = {
    
11.     "accept": "*/*",
    
12.     "accept-encoding": "gzip, deflate, br",
    
13.     "accept-language": "zh-CN,zh;q=0.9",
    
14.     "content-length": "278",
    
15.     "content-type": "application/json",
    
16.     "cookie":"_abtest_userid=0f540837-6c5a-4629-aa88-93ba1bfec570; _RSG=pHqDcQKOqkD92.7L6HsBL8; _RDG=28b4f4d49352f22e56153739a68cf82eae; _RGUID=dbb46146-a637-4473-854b-d911951fe089; MKT_CKID=1591713956511.w9k7w.9opk; _ga=GA1.2.1020029856.1591713957; _RF1=119.39.127.107; Session=smartlinkcode=U130709&smartlinklanguage=zh&SmartLinkKeyWord=&SmartLinkQuary=&SmartLinkHost=; Union=AllianceID=4901&SID=130709&OUID=&createtime=1599095310&Expires=1599700110468; MKT_CKID_LMT=1599095310492; MKT_Pagesource=PC; nfes_isSupportWebP=1; _jzqco=%7C%7C%7C%7C1599095310630%7C1.1301033936.1591713956505.1599095310501.1599095863824.1599095310501.1599095863824.0.0.0.3.3; __zpspc=9.2.1599095310.1599095863.2%233%7Cwww.sogou.com%7C%7C%7C%7C%23; _bfi=p1%3D290510%26p2%3D290510%26v1%3D4%26v2%3D3; _bfa=1.1591713953612.3xeul0.1.1591713953612.1599095307538.2.5; _bfs=1.4",
    
17.     "cookieorigin":"https://you.ctrip.com",
    
18.     "origin": "https://you.ctrip.com",
    
19.     "referer": "https://you.ctrip.com/sight/lijiang32/3049.html",
    
20.     "user-agent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.81 Safari/537.36 SE 2.X MetaSr 1.0"
    
21.     }
    
22. 
    
23. row = 0
    
24. col = 0
    
25. data = {"_fxpcqlniredt": "09031090311113380393"}
    
26. payload = {
    
27.         "arg":{"channelType": "2" ,                  
    
28.         "collapseType": "0",
    
29.         "commentTagId": "0",
    
30.         "pageIndex":"1",
    
31.         "pageSize": "10",
    
32.         "poiId": "75919",
    
33.         "sortType":" 3",
    
34.         "sourceType": "1",
    
35.         "starType": "0"},        
    
36.         }
    
37. url = "https://m.ctrip.com/restapi/soa2/13444/json/getCommentCollapseList?_fxpcqlniredt=09031090311113380393"
    
38. data = requests.post(url,headers = headers, params = data, data = json.dumps(payload),verify = False)
    
39. data.encoding = "utf-8"
    
40. resove_college_url = data.text
    
41. pat1 = '"content":"(.*?)",'
    
42. rest1 = re.compile(pat1,re.S).findall(resove_college_url)
    
43. 
    
44. for j in range(0,len(rest1)):
    
45.     print(rest1[j].encode("gbk","ignore").decode("gbk"))
    
46.     s = SnowNLP(rest1[j])
    
47.     print(s.sentiments)
    
48.     worksheet.write(row,col,rest1[j])
    
49.     worksheet.write(row,col+1,s.sentiments)
    
50. 
    
51. 
    
52. 
    

复制代码

运行后xls表格中没有存贮进数据，请问是哪里出错误了吗？

天边一抹灬红

你定义的row和col一直都是0

小小鹏

天边一抹灬红 发表于 2020-9-4 09:39
你定义的row和col一直都是0

我再后面加上row = row +１，col = col + 1,但是还是没有导入成功