def test_missing_content_type(datadir, DummyArchive): from ..workbook import detect_worksheets archive = DummyArchive datadir.chdir() with open("bug181_content_types.xml") as src: archive.writestr(ARC_CONTENT_TYPES, src.read()) with open("bug181_workbook.xml") as src: archive.writestr(ARC_WORKBOOK, src.read()) with open("bug181_workbook.xml.rels") as src: archive.writestr(ARC_WORKBOOK_RELS, src.read()) sheets = list(detect_worksheets(archive)) assert sheets == [{'path': 'xl/worksheets/sheet1.xml', 'title': 'Sheet 1'}]
def test_detect_worksheets(datadir, excel_file, expected): from openpyxl.reader.excel import detect_worksheets datadir.chdir() archive = ZipFile(excel_file) assert list(detect_worksheets(archive)) == expected