excel-runner

Run Http requests list in excel sheet

how to use

Install excel-runner v0.1.2

pip install excel-runner==0.1.2

Create excel data file data.xlsx

name	method	url	data	headers	verify
get请求	get	https://httpbin.org/get?a=1&b=2			res.status_code==200
post-form	post	https://httpbin.org/post	name=Kevin&age=1	Content-Type: application/x-www-form-urlencoded	res.status_code==200 res.json()['form']['name']=='Kevin']
post-json	post	https://httpbin.org/post	{"name": "Kevin", "age": 1}	Content-Type: application/json
post-xml	post	https://httpbin.org/post	hello	Content-Type: application/xml	result.json()["data"]=="hello"

Run excel data file

from excel_runner import run_excel

run_excel('data.xlsx')

Open data.xlsx again, you will see the test result

name	method	url	data	headers	verify	result
get请求	get	https://httpbin.org/get?a=1&b=2			res.status_code==200	PASS
post-form	post	https://httpbin.org/post	name=Kevin&age=1	Content-Type: application/x-www-form-urlencoded	res.status_code==200 res.json()['form']['name']=='Kevin']	PASS
post-json	post	https://httpbin.org/post	{"name": "Kevin", "age": 1}	Content-Type: application/json		PASS
post-xml	post	https://httpbin.org/post	hello	Content-Type: application/xml	result.json()["data"]=="hello"	PASS

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution for excel-runner 0.1.2
File	Size	Uploaded
excel_runner-0.1.2.tar.gz	11.7 kB	Sep 4, 2024	Details

Download URL	excel_runner-0.1.2.tar.gz
Size	11.7 kB
Tags	Source
SHA-256 checksum How to use checksums	`9425f40c0e8435e747209fe7de2a5b409c4d8425000240803996d6904c24868c`
BLAKE2b-256 checksum How to use checksums	`1be928777b9140b6d5f075a4de02085edf19aba273d71da7fe64dec9964cb509`
Upload date	Sep 4, 2024
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/5.1.1 CPython/3.9.6`