![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
python
weixin_41010890
这个作者很懒,什么都没留下…
展开
-
接口获取数据写入json文件
#-*-coding:utf-8-*-import openpyxlimport jsonimport requestsdef 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 · 408 阅读 · 0 评论 -
把excel数据写入到json文件
把excel数据写入到json文件#-*-coding:utf-8-*-import openpyxlimport jsondef 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 · 417 阅读 · 0 评论 -
requests发送get请求
# -*- coding:utf-8 -*-import requestsimport jsonurl="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 · 183 阅读 · 0 评论 -
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 · 3260 阅读 · 0 评论 -
python解析json文件
import jsonimport xlwtdef 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 · 117 阅读 · 0 评论