Metadata-Version: 2.1
Name: tesxcel
Version: 3.0.0
Summary: Utility functions to tests Microsoft Excel books
Home-page: https://colin-b.github.io/tesxcel/
Author: Colin Bounouar
Author-email: colin.bounouar.dev@gmail.com
Maintainer: Colin Bounouar
Maintainer-email: colin.bounouar.dev@gmail.com
License: MIT
Download-URL: https://pypi.org/project/tesxcel/
Project-URL: GitHub, https://github.com/Colin-b/tesxcel
Project-URL: Changelog, https://github.com/Colin-b/tesxcel/blob/master/CHANGELOG.md
Project-URL: Issues, https://github.com/Colin-b/tesxcel/issues
Keywords: excel,tests
Platform: Windows
Platform: Linux
Classifier: Development Status :: 5 - Production/Stable
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Natural Language :: English
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Topic :: Software Development :: Build Tools
Requires-Python: >=3.6
Description-Content-Type: text/markdown
Requires-Dist: openpyxl (==3.*)
Provides-Extra: testing
Requires-Dist: pytest-cov (==2.*) ; extra == 'testing'

<h2 align="center">Ensure Microsoft Excel books content with pytest</h2>

<p align="center">
<a href="https://pypi.org/project/tesxcel/"><img alt="pypi version" src="https://img.shields.io/pypi/v/tesxcel"></a>
<a href="https://travis-ci.org/Colin-b/tesxcel"><img alt="Build status" src="https://api.travis-ci.org/Colin-b/tesxcel.svg?branch=develop"></a>
<a href="https://travis-ci.org/Colin-b/tesxcel"><img alt="Coverage" src="https://img.shields.io/badge/coverage-100%25-brightgreen"></a>
<a href="https://github.com/psf/black"><img alt="Code style: black" src="https://img.shields.io/badge/code%20style-black-000000.svg"></a>
<a href="https://travis-ci.org/Colin-b/tesxcel"><img alt="Number of tests" src="https://img.shields.io/badge/tests-4 passed-blue"></a>
<a href="https://pypi.org/project/tesxcel/"><img alt="Number of downloads" src="https://img.shields.io/pypi/dm/tesxcel"></a>
</p>

Ensure that two Microsoft Excel files have the same cell types and content in every sheet.
Supported file formats are: `.xlsx`, `.xlsm`, `.xltx`, `.xltm`

```python
import tesxcel

def test_excel_file_using_path():
    tesxcel.assert_excel_content("/path/to/the/first_file.xlsx", "/path/to/the/second_file.xlsx")

def test_excel_file_using_content():
    received_excel_content: bytes = None
    tesxcel.assert_excel_content(received_excel_content, "/path/to/the/excel_file_to_compare.xlsx")
```

## How to install
1. [python 3.6+](https://www.python.org/downloads/) must be installed
2. Use pip to install module:
```sh
python -m pip install tesxcel
```


