test_excel_reader.py 文件源码

def invalid_excel_file_path(tmpdir):
    test_file_path = tmpdir.join("invalid.xlsx")
    workbook = xlsxwriter.Workbook(str(test_file_path))

    write_worksheet(workbook.add_worksheet("testsheet1"), table=[
        ["", "", "", ""],
        ["", "a", "", "c"],
        ["", "aa", "ab", ""],
        ["", "", 1.1, "a"],
    ])

    worksheet = workbook.add_worksheet("testsheet2")

    workbook.close()

    return str(test_file_path)