Ensure Microsoft Excel books content with pytest

pypi version Build status Coverage Code style: black Number of tests Number of downloads

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

  1. python 3.6+ must be installed
  2. Use pip to install module: 
    python -m pip install tesxcel