*misc

39 files changed, 244 insertions, 0 deletions

diff --git a/Tools/XlsToCsv/test/datetime.csv b/Tools/XlsToCsv/test/datetime.csv
new file mode 100644
index 0000000..a789017
--- /dev/null
+++ b/Tools/XlsToCsv/test/datetime.csv
@@ -0,0 +1 @@
+2011-09-15 15:22:00

diff --git a/Tools/XlsToCsv/test/datetime.xlsx b/Tools/XlsToCsv/test/datetime.xlsx
new file mode 100644
index 0000000..340fa78
--- /dev/null
+++ b/Tools/XlsToCsv/test/datetime.xlsx
diff --git a/Tools/XlsToCsv/test/empty_row.csv b/Tools/XlsToCsv/test/empty_row.csv
new file mode 100644
index 0000000..9557b99
--- /dev/null
+++ b/Tools/XlsToCsv/test/empty_row.csv
@@ -0,0 +1,3 @@
+,,,,,,,,,,,,
+Date,Agency,Customer,Campaign,Publisher,Format,Inventory,Impressions,Clicks,CTR (%),Price,Price model,Revenue
+At the moment no data for report,,,,,,,,,,,,
diff --git a/Tools/XlsToCsv/test/empty_row.xlsx b/Tools/XlsToCsv/test/empty_row.xlsx
new file mode 100644
index 0000000..fb7e1cf
--- /dev/null
+++ b/Tools/XlsToCsv/test/empty_row.xlsx
diff --git a/Tools/XlsToCsv/test/escape.csv b/Tools/XlsToCsv/test/escape.csv
new file mode 100644
index 0000000..a33b914
--- /dev/null
+++ b/Tools/XlsToCsv/test/escape.csv
@@ -0,0 +1 @@
+,,,,Hello\nWorld\t!,FALSE
diff --git a/Tools/XlsToCsv/test/escape.xlsx b/Tools/XlsToCsv/test/escape.xlsx
new file mode 100644
index 0000000..57707fe
--- /dev/null
+++ b/Tools/XlsToCsv/test/escape.xlsx
diff --git a/Tools/XlsToCsv/test/float.csv b/Tools/XlsToCsv/test/float.csv
new file mode 100644
index 0000000..f0723b1
--- /dev/null
+++ b/Tools/XlsToCsv/test/float.csv
@@ -0,0 +1,5 @@
+
+0.10300
+0.27600
+0.10300
+0.27600
diff --git a/Tools/XlsToCsv/test/float.xlsx b/Tools/XlsToCsv/test/float.xlsx
new file mode 100644
index 0000000..9c43167
--- /dev/null
+++ b/Tools/XlsToCsv/test/float.xlsx
diff --git a/Tools/XlsToCsv/test/hyperlinks.csv b/Tools/XlsToCsv/test/hyperlinks.csv
new file mode 100644
index 0000000..4b8aaf7
--- /dev/null
+++ b/Tools/XlsToCsv/test/hyperlinks.csv
@@ -0,0 +1 @@
+<a href='https://www.google.com/'>google</a>,<a href='https://www.yahoo.com/'>yahoo</a>,<a href='https://www.gmail.com/'>gmail</a>,<a href='http://www.reddit.com/'>reddit</a>,<a href='https://github.com/'>github</a>
diff --git a/Tools/XlsToCsv/test/hyperlinks.xlsm b/Tools/XlsToCsv/test/hyperlinks.xlsm
new file mode 100644
index 0000000..d028025
--- /dev/null
+++ b/Tools/XlsToCsv/test/hyperlinks.xlsm
diff --git a/Tools/XlsToCsv/test/hyperlinks_continous.csv b/Tools/XlsToCsv/test/hyperlinks_continous.csv
new file mode 100644
index 0000000..81fc63c
--- /dev/null
+++ b/Tools/XlsToCsv/test/hyperlinks_continous.csv
@@ -0,0 +1,18 @@
+<a href='http://google.com/'>google</a>,<a href='http://google.com/'>test</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://reddit.com/'>reddit</a>
+<a href='http://google.com/'>google</a>,<a href='http://google.com/'>test</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://reddit.com/'>reddit</a>
+<a href='http://google.com/'>google</a>,<a href='http://google.com/'>test</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://reddit.com/'>reddit</a>
+<a href='http://google.com/'>google</a>,<a href='http://google.com/'>test</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://reddit.com/'>reddit</a>
+<a href='http://google.com/'>google</a>,<a href='http://google.com/'>test</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://reddit.com/'>reddit</a>
+<a href='http://google.com/'>google</a>,<a href='http://google.com/'>test</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://reddit.com/'>reddit</a>
+<a href='http://google.com/'>google</a>,<a href='http://google.com/'>test</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://reddit.com/'>reddit</a>
+<a href='http://google.com/'>google</a>,<a href='http://google.com/'>test</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://reddit.com/'>reddit</a>
+<a href='http://google.com/'>google</a>,<a href='http://google.com/'>test</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://reddit.com/'>reddit</a>
+<a href='http://reddit.com/'>reddit</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://google.com/'>test</a>,<a href='http://google.com/'>google</a>
+<a href='http://reddit.com/'>reddit</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://google.com/'>test</a>,<a href='http://google.com/'>google</a>
+<a href='http://reddit.com/'>reddit</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://google.com/'>test</a>,<a href='http://google.com/'>google</a>
+<a href='http://reddit.com/'>reddit</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://google.com/'>test</a>,<a href='http://google.com/'>google</a>
+<a href='http://reddit.com/'>reddit</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://google.com/'>test</a>,<a href='http://google.com/'>google</a>
+<a href='http://reddit.com/'>reddit</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://google.com/'>test</a>,<a href='http://google.com/'>google</a>
+<a href='http://reddit.com/'>reddit</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://google.com/'>test</a>,<a href='http://google.com/'>google</a>
+<a href='http://reddit.com/'>reddit</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://google.com/'>test</a>,<a href='http://google.com/'>google</a>
+<a href='http://reddit.com/'>reddit</a>,<a href='http://yahoo.com/'>yahoo</a>,<a href='http://google.com/'>test</a>,<a href='http://google.com/'>google</a>
diff --git a/Tools/XlsToCsv/test/hyperlinks_continous.xlsm b/Tools/XlsToCsv/test/hyperlinks_continous.xlsm
new file mode 100644
index 0000000..ddea849
--- /dev/null
+++ b/Tools/XlsToCsv/test/hyperlinks_continous.xlsm
diff --git a/Tools/XlsToCsv/test/input-weird.csv b/Tools/XlsToCsv/test/input-weird.csv
new file mode 100644
index 0000000..bdc150a
--- /dev/null
+++ b/Tools/XlsToCsv/test/input-weird.csv
@@ -0,0 +1,2 @@
+,,,
+Some data,,,
diff --git a/Tools/XlsToCsv/test/input-weird.xlsx b/Tools/XlsToCsv/test/input-weird.xlsx
new file mode 100644
index 0000000..c8f74a2
--- /dev/null
+++ b/Tools/XlsToCsv/test/input-weird.xlsx
diff --git a/Tools/XlsToCsv/test/junk-small.csv b/Tools/XlsToCsv/test/junk-small.csv
new file mode 100644
index 0000000..5212eac
--- /dev/null
+++ b/Tools/XlsToCsv/test/junk-small.csv
@@ -0,0 +1 @@
+29-Mar-1940,25-Jul-2008,08-07-25,08-Apr-2009,test,FALSE

diff --git a/Tools/XlsToCsv/test/junk-small.xlsx b/Tools/XlsToCsv/test/junk-small.xlsx
new file mode 100644
index 0000000..ba720df
--- /dev/null
+++ b/Tools/XlsToCsv/test/junk-small.xlsx
diff --git a/Tools/XlsToCsv/test/last-column-empty.csv b/Tools/XlsToCsv/test/last-column-empty.csv
new file mode 100644
index 0000000..0b90178
--- /dev/null
+++ b/Tools/XlsToCsv/test/last-column-empty.csv
@@ -0,0 +1,6 @@
+A,B,C

+stuff,more stuff,

+things,more things,even more things

+a,b,

+one,two,

+1,2,3

diff --git a/Tools/XlsToCsv/test/last-column-empty.xlsx b/Tools/XlsToCsv/test/last-column-empty.xlsx
new file mode 100644
index 0000000..4fbaf40
--- /dev/null
+++ b/Tools/XlsToCsv/test/last-column-empty.xlsx
diff --git a/Tools/XlsToCsv/test/namespace.csv b/Tools/XlsToCsv/test/namespace.csv
new file mode 100644
index 0000000..eff7861
--- /dev/null
+++ b/Tools/XlsToCsv/test/namespace.csv
@@ -0,0 +1,7 @@
+Case # (aka tissue code):,,,,SW101014-03,,,,,,,,,,,+,very light
+Injection Site Location (PHAL/CTB):,,,,VISC Visceral Cortex (VISC) encroaching on the Gustatory Cortex (GU),,,,,,,,,,,++,light
+Injection Site Location (BDA/FG):,,,,Ssp Primary Somatosensory Cortex (SSp) Layers 4 and 5,,,,,,,,,,,+++,moderate
+,,,,,,,,,,,,,,,++++,strong
+Summary Notes:,,,,CTb and BDA did not work,,,,,,,,,,,,
+Atlas level,Data section  (File Name),Data section (LIMS),Anatomical Abbr,Anatomical Structure,PHAL,,,CTB,,,BDA,,,FG,,
+,,,,,Contra,Ipsi,Notes,Contra,Ipsi,Notes,Contra,Ipsi,Notes,Contra,Ipsi,Notes
diff --git a/Tools/XlsToCsv/test/namespace.xlsx b/Tools/XlsToCsv/test/namespace.xlsx
new file mode 100644
index 0000000..4f92bee
--- /dev/null
+++ b/Tools/XlsToCsv/test/namespace.xlsx
diff --git a/Tools/XlsToCsv/test/no_cell_ids.csv b/Tools/XlsToCsv/test/no_cell_ids.csv
new file mode 100644
index 0000000..9557b99
--- /dev/null
+++ b/Tools/XlsToCsv/test/no_cell_ids.csv
@@ -0,0 +1,3 @@
+,,,,,,,,,,,,
+Date,Agency,Customer,Campaign,Publisher,Format,Inventory,Impressions,Clicks,CTR (%),Price,Price model,Revenue
+At the moment no data for report,,,,,,,,,,,,
diff --git a/Tools/XlsToCsv/test/no_cell_ids.xlsx b/Tools/XlsToCsv/test/no_cell_ids.xlsx
new file mode 100644
index 0000000..59c3d64
--- /dev/null
+++ b/Tools/XlsToCsv/test/no_cell_ids.xlsx
diff --git a/Tools/XlsToCsv/test/run b/Tools/XlsToCsv/test/run
new file mode 100644
index 0000000..990421c
--- /dev/null
+++ b/Tools/XlsToCsv/test/run
@@ -0,0 +1,63 @@
+#!/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"])
diff --git a/Tools/XlsToCsv/test/sheets.csv b/Tools/XlsToCsv/test/sheets.csv
new file mode 100644
index 0000000..a0fb509
--- /dev/null
+++ b/Tools/XlsToCsv/test/sheets.csv
@@ -0,0 +1,28 @@
+-------- 1 - Реестр

+№,URL,Название,Вер.,Сост.,Аналитик,Заказчик

+1,url,<<Шаблон сценария>>,1.0,Подп.,Фамилия ,Фамилия

+2,,,,,,

+3,,,,,,

+4,,,,,,

+5,,,,,,

+-------- 2 - Вариант использования

+№,Элемент,Описание,Результат шага (Выход),Ссылки

+1,Номер,Полный код (номер) сценария,,

+2,Название,Полное название сценария,,

+3,Описание,Краткое описание сути сценария,,

+4,Тип,Тип сценария / Уровень сценария - можно опустить из описания,,

+5,Наследует,Какой сценарий является родительским (базовым) для данного сценария,,

+6.1,Актер ,Кто основное действующее лицо. Если есть еще - добавляем,,

+6.2,Система,Кто основное действующее лицо с позиции системы (продукта). Если есть еще - добавляем,,

+7.1,Цель,Одна или несколько определенных целей для сценария,Целевой показатель,

+7.2,Цель,,,

+7.3,Цель,,,

+8.1,Шаг,Описание шага - кто что делает / с кем-чем взаимодействует,Артефакт на выходе,

+8.2,Шаг,,,

+8.х,Шаг,,,

+9,Альт/Искл.,название альтернативного потока / исключения,,

+9.1,Шаг,,,

+9.х,Шаг,,,

+10,Альт/Искл.,название альтернативного потока / исключения,,

+10.1,Шаг,,,

+10.х,Шаг,,,

diff --git a/Tools/XlsToCsv/test/sheets.xlsx b/Tools/XlsToCsv/test/sheets.xlsx
new file mode 100644
index 0000000..70d1a20
--- /dev/null
+++ b/Tools/XlsToCsv/test/sheets.xlsx
diff --git a/Tools/XlsToCsv/test/sheets_order.csv b/Tools/XlsToCsv/test/sheets_order.csv
new file mode 100644
index 0000000..e5820c4
--- /dev/null
+++ b/Tools/XlsToCsv/test/sheets_order.csv
@@ -0,0 +1,47 @@
+-------- 1 - b
+x,y
+-10,-1000
+-9,-729
+-8,-512
+-7,-343
+-6,-216
+-5,-125
+-4,-64
+-3,-27
+-2,-8
+-1,-1
+0,0
+1,1
+2,8
+3,27
+4,64
+5,125
+6,216
+7,343
+8,512
+9,729
+10,1000
+11,1331
+12,1728
+13,2197
+14,2744
+-------- 2 - e
+EEEEE
+EEEE
+EEE
+EE
+E
+-------- 3 - d
+DDDD
+DDD
+DD
+D
+-------- 4 - a
+AAAAAAA
+AAAA
+AAA
+AA
+AA
+AAA
+AAAA
+AAAAAAA
diff --git a/Tools/XlsToCsv/test/sheets_order.xlsx b/Tools/XlsToCsv/test/sheets_order.xlsx
new file mode 100644
index 0000000..ba782c3
--- /dev/null
+++ b/Tools/XlsToCsv/test/sheets_order.xlsx
diff --git a/Tools/XlsToCsv/test/skip_empty_lines.csv b/Tools/XlsToCsv/test/skip_empty_lines.csv
new file mode 100644
index 0000000..4362b53
--- /dev/null
+++ b/Tools/XlsToCsv/test/skip_empty_lines.csv
@@ -0,0 +1,3 @@
+№,URL,Название,Вер.,Сост.,Аналитик,Заказчик

+1,url,<<Шаблон сценария>>,1.0,Подп.,Фамилия ,Фамилия

+3,,,,,,

diff --git a/Tools/XlsToCsv/test/skip_empty_lines.xlsx b/Tools/XlsToCsv/test/skip_empty_lines.xlsx
new file mode 100644
index 0000000..82c6600
--- /dev/null
+++ b/Tools/XlsToCsv/test/skip_empty_lines.xlsx
diff --git a/Tools/XlsToCsv/test/timeformat.csv b/Tools/XlsToCsv/test/timeformat.csv
new file mode 100644
index 0000000..472fd3b
--- /dev/null
+++ b/Tools/XlsToCsv/test/timeformat.csv
@@ -0,0 +1,3 @@
+"03""-""08""-""2017"" ""14:35:00",14:40
+"03""-""08""-""2017"" ""00:00:00",11:30
+"03""-""08""-""2017"" ""15:40:00",00:01
diff --git a/Tools/XlsToCsv/test/timeformat.xlsx b/Tools/XlsToCsv/test/timeformat.xlsx
new file mode 100644
index 0000000..4e8f218
--- /dev/null
+++ b/Tools/XlsToCsv/test/timeformat.xlsx
diff --git a/Tools/XlsToCsv/test/twolettercolumns.csv b/Tools/XlsToCsv/test/twolettercolumns.csv
new file mode 100644
index 0000000..c9e3abb
--- /dev/null
+++ b/Tools/XlsToCsv/test/twolettercolumns.csv
@@ -0,0 +1,2 @@
+1,2,3,4,5,6,7,8,9,,,,,,,,,,,,,,,,,10,11,12

+a,b,c,d,e,f,g,,,,,,,,,,,,,,,,,,,h,I,j

diff --git a/Tools/XlsToCsv/test/twolettercolumns.xlsx b/Tools/XlsToCsv/test/twolettercolumns.xlsx
new file mode 100644
index 0000000..b25cbff
--- /dev/null
+++ b/Tools/XlsToCsv/test/twolettercolumns.xlsx
diff --git a/Tools/XlsToCsv/test/utf8.csv b/Tools/XlsToCsv/test/utf8.csv
new file mode 100644
index 0000000..2b4212b
--- /dev/null
+++ b/Tools/XlsToCsv/test/utf8.csv
@@ -0,0 +1,5 @@
+สวัสดี ครับ,Thai language
+こんにちは,Japanese language
+Здравствуйте,Russian language
+नमस्ते,Hindi
+السلام عليكم,Arabic
diff --git a/Tools/XlsToCsv/test/utf8.xlsx b/Tools/XlsToCsv/test/utf8.xlsx
new file mode 100644
index 0000000..509d5e4
--- /dev/null
+++ b/Tools/XlsToCsv/test/utf8.xlsx
diff --git a/Tools/XlsToCsv/test/variousdelim.csv b/Tools/XlsToCsv/test/variousdelim.csv
new file mode 100644
index 0000000..10e5ae3
--- /dev/null
+++ b/Tools/XlsToCsv/test/variousdelim.csv
@@ -0,0 +1 @@
+! 1 - Sheet1
1	2	3
a	b	c
! 2 - Sheet2
4	5	6
d	e	f
\ No newline at end of file
diff --git a/Tools/XlsToCsv/test/variousdelim.xlsx b/Tools/XlsToCsv/test/variousdelim.xlsx
new file mode 100644
index 0000000..fc2382b
--- /dev/null
+++ b/Tools/XlsToCsv/test/variousdelim.xlsx
diff --git a/Tools/XlsToCsv/test/xlsx2csv-test-file.csv b/Tools/XlsToCsv/test/xlsx2csv-test-file.csv
new file mode 100644
index 0000000..ec474c4
--- /dev/null
+++ b/Tools/XlsToCsv/test/xlsx2csv-test-file.csv
@@ -0,0 +1,44 @@
+A,B,C
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+,MSP,
+blah,PPS,
+blah,PPS,
+blah,PPS,
+blah,PPS,
+blah,PPS,
+blah,PPS,
+blah,PPS,
+blah,PPS,
+blah,PPS,
+blah,PPS,
+blah,PPS,
+blah,PPS,
diff --git a/Tools/XlsToCsv/test/xlsx2csv-test-file.xlsx b/Tools/XlsToCsv/test/xlsx2csv-test-file.xlsx
new file mode 100644
index 0000000..828cfd7
--- /dev/null
+++ b/Tools/XlsToCsv/test/xlsx2csv-test-file.xlsx