pytest-excel is a plugin for py.test that allows to to create excel report for test results.
You will need the following prerequisites in order to use pytest-excel:
- Python 3.11 and above
- pytest
- pandas
- openpyxl
To install pytest-excel and required dependencies:
$ pip install pytest-excel openpyxl
Then run your tests with:
$ py.test --excelreport=report.xls
If you would like more detailed output (one test per line), then you may use the verbose option:
$ py.test --verbose
If you would like to run tests without execution to collect test doc string:
$ py.test --excelreport=report.xls --collect-only
If you would like to get timestamp in the as filename:
$ py.test --excelreport=report%Y-%M-dT%H%.xls