- 博客(6)
- 收藏
- 关注
RSS订阅原创 接口获取数据写入json文件
#-*-coding:utf-8-*- import openpyxl import json import requests def readExcel(): wb=openpyxl.load_workbook(r'D:\ruanjian\learn\os\testcase\sku_3c_7_1105.xlsx') sheet=wb['sku_3c_7_1105(1)'] max_row = sheet.max_row max_col = sheet.max_column
2020-11-19 14:55:23
418
原创 把excel数据写入到json文件
把excel数据写入到json文件 #-*-coding:utf-8-*- import openpyxl import json def ExcelJson(): wb=openpyxl.load_workbook(r'D:\zhiang\项目\售前指标\os.xlsx') sheet=wb['sheet1'] sku_id=[] sku_name=[] max_row=sheet.max_row for i in range(2,max_row+1):#
2020-11-19 11:14:12
432
原创 requests发送post请求form-data格式
def main():xxxx url="要访问的url" headers={ 'Accept':'application/json, text/plain, */*', 'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)xxxx Chrome/86.0.4240.111 Safari/537.36', 'R
2020-11-10 18:33:08
3313
原创 requests发送get请求
# -*- coding:utf-8 -*- import requests import json url="https://xxx/comment/productPageComments.action?callback=fetchJSON_comment98&productId=100005769525&score=0&sortType=5&page=1&pageSize=10&isShadowSku=0&rid=0&fold=1" hea
2020-11-10 18:24:30
233
原创 python解析json文件
import json import xlwt def loadFont(): f = open(“2020110386440427.json”, encoding=‘utf-8’) setting = json.load(f) family = setting[‘hits’][‘hits’] #[0][’_source’][‘cust_ser_acct_no’] pin_list=[] shop_supplier_id=[] shop_supplier_name=[] order_d7_sale_qtty
2020-11-10 18:20:41
124
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人