python3.7上传excel与下载excel,测试接口中,会遇到上传的文件是excel\jpg图片等,下载的文件也是excel\jpg图片等情况;现在已excel文件举例说明一下:
1、上传文件:
1)先定义文件参数filexls = {‘file’: open( ‘D:\20190619 044103.xls’, ‘rb’)} 为打开需要上传的文件; 'D:\20190619 044103.xls’为文件名
2)再调用接口参数,传入requests,获取接口返回值;
原代码:
#上传接口
import datetime
import itertools
import time
import requests
def FileUpload():
url = "http://FileUpload" # 获取url
# header获取
header = {
'Cookie': 'ASP.NET_SessionId=session值'} #通常上传文件一般是在登录之后调用的接口,这里需要调用登录态
n = 0
filexls = {
'file': open( 'D:\20190619 044103.xls', 'rb')}
filexlsx = {
'file': open('D:\20190619 044103.xlsx','rb')}
filetxt = {
'file': open('D:\注意事项.txt','rb')}
filename = ('',filexls, filexlsx,filetxt)
today = time.strftime('%Y%m%d', time.localtime(int(time.time())))
Yesterday = (datetime.datetime.now() - datetime.timedelta(days=7)).strftime('%Y-%m-%d')
ThreeMonthIn = (datetime.datetime.now()