爬取华为应用市场拼多多评论并写入EXCEL

import requests
from requests.exceptions import RequestException
import json
import xlwt

def getcomment(url):
    try:
        headers = {
            'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36'
        }
        response = requests.get(url,headers=headers)
        if response.status_code == 200:
                return response.text
        else:
            return 'no200'
    except RequestException:
        return None

def main(pagestartnum ,pageendnum):
    new_workbook = xlwt.Workbook()
    for i in range(pagestartnum,pageendnum):
        url = 'https://web-drcn.hispace.dbankcloud.cn/uowap/index?method=internal.user.commenList3&serviceType=20&reqPageNum='+str(i)\
              +'&maxResults=25&appid=C10374976&version=10.0.0&zone=&loca