python打印结果数据

保存TXT文件

import requests
doc=open(‘out.txt’,’w’)
from urllib import parse
url = ‘http://testapi3.bandzo.com/api/Store/Popular’
headers = {‘Accept-Language’:’zh-CN’,’AppType’:’iphone’}
r = requests.post(url,data = {‘StoreID’:’3’},headers=headers)
result=r.json()
token=result.get(‘status’)
print(token,file=doc)

保存excel文件

import requests
import json
from openpyxl import load_workbook
from urllib import parse
url = ‘http://testapi3.bandzo.com/api/Store/Popular’
headers = {‘Accept-Language’:’zh-CN’,’AppType’:’iphone’}
r = requests.post(url,data = {‘StoreID’:’3’},headers=headers)
result=r.json()
token=result.get(‘status’)

if name==”main“:
filepath = ‘111.xlsx’
wb = load_workbook (filename = filepath)
ws = wb[‘Sheet1’]
ws[‘A1’] = token
wb.save(filepath)