diff options
author | chai <chaifix@163.com> | 2021-10-26 12:20:33 +0800 |
---|---|---|
committer | chai <chaifix@163.com> | 2021-10-26 12:20:33 +0800 |
commit | 3b79158563fd2f7f72d502067f178d60c31b2c28 (patch) | |
tree | 1b583739439a00c4d347a6533a8424b153fbcbd1 /Tools/XlsToCsv/test/run | |
parent | 0549b1e5a8a3132005e275d6026db8003cb067d2 (diff) |
+xlsxToCSV
Diffstat (limited to 'Tools/XlsToCsv/test/run')
-rw-r--r-- | Tools/XlsToCsv/test/run | 63 |
1 files changed, 0 insertions, 63 deletions
diff --git a/Tools/XlsToCsv/test/run b/Tools/XlsToCsv/test/run deleted file mode 100644 index 990421c..0000000 --- a/Tools/XlsToCsv/test/run +++ /dev/null @@ -1,63 +0,0 @@ -#!/usr/bin/env python - -import os -import sys -import subprocess -from io import open - -PYTHON_VERSIONS = ["2", "3"] - -""" -This test uses sys.stdout. -That means this test doesn't verify: - - file output process - - differences from sys.stdout like line terminater -""" - -def compare(case, arguments=[]): - failed = False - for pyver in PYTHON_VERSIONS: - ext = "xlsx" - if os.path.exists("test/%s.xlsm" % case): - ext = "xlsm" - - if os.name == 'posix':# in case of Linux - left = subprocess.check_output(["python%s" %pyver, "./xlsx2csv.py"] + arguments + ["test/%s.%s" %(case, ext)]).decode('utf-8').replace('\r','') - elif os.name == 'nt':# in case of Windows - # Use py.exe http://blog.python.org/2011/07/python-launcher-for-windows_11.html on Windows - left = subprocess.check_output(["py", "-%s" %pyver, "./xlsx2csv.py"] + arguments + ["test/%s.%s" %(case, ext)]).decode('utf-8').replace('\r','') - else: - print("os.name is unexpected: "+os.name) - sys.exit(1) - - f = open("test/%s.csv" %case, "r", encoding="utf-8", newline="") - right = f.read().replace('\r','') - f.close() - - if left != right: - print("FAILED: %s %s" %(case, pyver)) - print(" actual:", left.replace("\r", "\\r").replace("\n", "\\n")) - print(" expected:", right.replace("\r", "\\r").replace("\n", "\\n")) - failed = True - else: - print("OK: %s %s" %(case, pyver)) - if failed: - sys.exit(1) - -compare("datetime", ["--dateformat=%Y-%m-%d %H:%M:%S"]) -compare("empty_row") -compare("junk-small") -compare("last-column-empty") -compare("sheets", ["-a"]) -compare("skip_empty_lines", ["-i"]) -compare("twolettercolumns") -compare("xlsx2csv-test-file") -compare("escape", ["-e"]) -compare("hyperlinks", ["--hyperlinks"]) -compare("hyperlinks_continous", ["--hyperlinks"]) -compare("namespace") -compare("float") -compare("variousdelim", ["--all","--sheetdelimiter=x33", "--lineterminator=\\r", "--delimiter=\\t"]) -compare("utf8") -compare("no_cell_ids") -compare("sheets_order", ["-a"]) |