📦 Colin-b / tesxcel

Ensure Microsoft Excel books content with pytest

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

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

• python 3.6+ must be installed
• Use pip to install module:

python -m pip install tesxcel