求大神帮我看下，我的代码把接收的进EXCEL，修改

recvmsg_new.rar (1003 Bytes, 下载次数: 0)

2022-1-14 14:31 上传

点击文件名下载附件

import json
from wsgiref.simple_server import make_server
import urllib.parse
import re
import openpyxl #导入openpyxl模块

def application(environ, start_resp**e):
   if environ["REQUEST_METHOD"] == "GET":
      return [b'get.ok', ]
   # 定义文件请求的类型和当前请求成功的code
   start_resp**e('200 OK', [('Content-Type', 'application/json')])
   # environ是当前请求的所有数据，包括Header和URL，body
   request_body = environ["wsgi.input"].read(int(environ.get("CONTENT_LENGTH", 0)))
   json_str = request_body.decode('utf-8') # byte 转 str
   json_str = re.sub('\'','\"', json_str) # 单引号转双引号, json.loads 必须使用双引号
   json_dict = json.loads(json_str) #（注意：key值必须双引号）
   print(json_dict)
   return [b'welcome', ]





if __name__ == "__main__":
   port = 8888
   httpd = make_server("0.0.0.0", port , application)
   print("serving http on port {0}...".format(str(port)))
   httpd.serve_forever()
   wb = openpyxl.Workbook()
   wb.save('excel.xlsx') #保存文件
    #wb = openpyxl.load_workbook('excel.xlsx')
        #wb = openpyxl.load_workbook("数据.xlsx")
       # wb.save("数据.xlsx")
        #sheet['A1'] = 'msgtype'
        #sheet['B1'] = 'wxid'
        #sheet['C1'] = 'content'
        #sheet['D1'] = 'filepath'
        #sheet['E1'] = 'sender'
        #sheet['F1'] = 'source'
        #sheet['G1'] = 'isphonemsg'
        #sheet['H1'] = 'selfwxid'        
        #for each in range(len(json_dict)):
        #sheet['A' + str(each+2)] = str(json_dict[each]['msgtype'])
        ##sheet['B' + str(each+2)] = str(json_dict[each]['wxid'])
        ##sheet['C' + str(each+2)] = str(json_dict[each]['content'])
        ##sheet['D' + str(each+2)] = str(json_dict[each]['filepath'])
        ##sheet['E' + str(each+2)] = str(json_dict[each]['sender'])
        ##sheet['F' + str(each+2)] = str(json_dict[each]['source'])
        ##sheet['G' + str(each+2)] = str(json_dict[each]['isphonemsg'])
        ##sheet['H' + str(each+2)] = str(json_dict[each]['selfwxid'])

顶起来哈