diff options
Diffstat (limited to 'Tools/XlsToCsv/test')
39 files changed, 0 insertions, 244 deletions
diff --git a/Tools/XlsToCsv/test/datetime.csv b/Tools/XlsToCsv/test/datetime.csv deleted file mode 100644 index a789017..0000000 --- a/Tools/XlsToCsv/test/datetime.csv +++ /dev/null @@ -1 +0,0 @@ -2011-09-15 15:22:00
diff --git a/Tools/XlsToCsv/test/datetime.xlsx b/Tools/XlsToCsv/test/datetime.xlsx Binary files differdeleted file mode 100644 index 340fa78..0000000 --- a/Tools/XlsToCsv/test/datetime.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/empty_row.csv b/Tools/XlsToCsv/test/empty_row.csv deleted file mode 100644 index 9557b99..0000000 --- a/Tools/XlsToCsv/test/empty_row.csv +++ /dev/null @@ -1,3 +0,0 @@ -,,,,,,,,,,,, -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 Binary files differdeleted file mode 100644 index fb7e1cf..0000000 --- a/Tools/XlsToCsv/test/empty_row.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/escape.csv b/Tools/XlsToCsv/test/escape.csv deleted file mode 100644 index a33b914..0000000 --- a/Tools/XlsToCsv/test/escape.csv +++ /dev/null @@ -1 +0,0 @@ -,,,,Hello\nWorld\t!,FALSE diff --git a/Tools/XlsToCsv/test/escape.xlsx b/Tools/XlsToCsv/test/escape.xlsx Binary files differdeleted file mode 100644 index 57707fe..0000000 --- a/Tools/XlsToCsv/test/escape.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/float.csv b/Tools/XlsToCsv/test/float.csv deleted file mode 100644 index f0723b1..0000000 --- a/Tools/XlsToCsv/test/float.csv +++ /dev/null @@ -1,5 +0,0 @@ - -0.10300 -0.27600 -0.10300 -0.27600 diff --git a/Tools/XlsToCsv/test/float.xlsx b/Tools/XlsToCsv/test/float.xlsx Binary files differdeleted file mode 100644 index 9c43167..0000000 --- a/Tools/XlsToCsv/test/float.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/hyperlinks.csv b/Tools/XlsToCsv/test/hyperlinks.csv deleted file mode 100644 index 4b8aaf7..0000000 --- a/Tools/XlsToCsv/test/hyperlinks.csv +++ /dev/null @@ -1 +0,0 @@ -<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 Binary files differdeleted file mode 100644 index d028025..0000000 --- a/Tools/XlsToCsv/test/hyperlinks.xlsm +++ /dev/null diff --git a/Tools/XlsToCsv/test/hyperlinks_continous.csv b/Tools/XlsToCsv/test/hyperlinks_continous.csv deleted file mode 100644 index 81fc63c..0000000 --- a/Tools/XlsToCsv/test/hyperlinks_continous.csv +++ /dev/null @@ -1,18 +0,0 @@ -<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 Binary files differdeleted file mode 100644 index ddea849..0000000 --- a/Tools/XlsToCsv/test/hyperlinks_continous.xlsm +++ /dev/null diff --git a/Tools/XlsToCsv/test/input-weird.csv b/Tools/XlsToCsv/test/input-weird.csv deleted file mode 100644 index bdc150a..0000000 --- a/Tools/XlsToCsv/test/input-weird.csv +++ /dev/null @@ -1,2 +0,0 @@ -,,, -Some data,,, diff --git a/Tools/XlsToCsv/test/input-weird.xlsx b/Tools/XlsToCsv/test/input-weird.xlsx Binary files differdeleted file mode 100644 index c8f74a2..0000000 --- a/Tools/XlsToCsv/test/input-weird.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/junk-small.csv b/Tools/XlsToCsv/test/junk-small.csv deleted file mode 100644 index 5212eac..0000000 --- a/Tools/XlsToCsv/test/junk-small.csv +++ /dev/null @@ -1 +0,0 @@ -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 Binary files differdeleted file mode 100644 index ba720df..0000000 --- a/Tools/XlsToCsv/test/junk-small.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/last-column-empty.csv b/Tools/XlsToCsv/test/last-column-empty.csv deleted file mode 100644 index 0b90178..0000000 --- a/Tools/XlsToCsv/test/last-column-empty.csv +++ /dev/null @@ -1,6 +0,0 @@ -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 Binary files differdeleted file mode 100644 index 4fbaf40..0000000 --- a/Tools/XlsToCsv/test/last-column-empty.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/namespace.csv b/Tools/XlsToCsv/test/namespace.csv deleted file mode 100644 index eff7861..0000000 --- a/Tools/XlsToCsv/test/namespace.csv +++ /dev/null @@ -1,7 +0,0 @@ -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 Binary files differdeleted file mode 100644 index 4f92bee..0000000 --- a/Tools/XlsToCsv/test/namespace.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/no_cell_ids.csv b/Tools/XlsToCsv/test/no_cell_ids.csv deleted file mode 100644 index 9557b99..0000000 --- a/Tools/XlsToCsv/test/no_cell_ids.csv +++ /dev/null @@ -1,3 +0,0 @@ -,,,,,,,,,,,, -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 Binary files differdeleted file mode 100644 index 59c3d64..0000000 --- a/Tools/XlsToCsv/test/no_cell_ids.xlsx +++ /dev/null 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"]) diff --git a/Tools/XlsToCsv/test/sheets.csv b/Tools/XlsToCsv/test/sheets.csv deleted file mode 100644 index a0fb509..0000000 --- a/Tools/XlsToCsv/test/sheets.csv +++ /dev/null @@ -1,28 +0,0 @@ --------- 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 Binary files differdeleted file mode 100644 index 70d1a20..0000000 --- a/Tools/XlsToCsv/test/sheets.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/sheets_order.csv b/Tools/XlsToCsv/test/sheets_order.csv deleted file mode 100644 index e5820c4..0000000 --- a/Tools/XlsToCsv/test/sheets_order.csv +++ /dev/null @@ -1,47 +0,0 @@ --------- 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 Binary files differdeleted file mode 100644 index ba782c3..0000000 --- a/Tools/XlsToCsv/test/sheets_order.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/skip_empty_lines.csv b/Tools/XlsToCsv/test/skip_empty_lines.csv deleted file mode 100644 index 4362b53..0000000 --- a/Tools/XlsToCsv/test/skip_empty_lines.csv +++ /dev/null @@ -1,3 +0,0 @@ -№,URL,Название,Вер.,Сост.,Аналитик,Заказчик
-1,url,<<Шаблон сценария>>,1.0,Подп.,Фамилия ,Фамилия
-3,,,,,,
diff --git a/Tools/XlsToCsv/test/skip_empty_lines.xlsx b/Tools/XlsToCsv/test/skip_empty_lines.xlsx Binary files differdeleted file mode 100644 index 82c6600..0000000 --- a/Tools/XlsToCsv/test/skip_empty_lines.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/timeformat.csv b/Tools/XlsToCsv/test/timeformat.csv deleted file mode 100644 index 472fd3b..0000000 --- a/Tools/XlsToCsv/test/timeformat.csv +++ /dev/null @@ -1,3 +0,0 @@ -"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 Binary files differdeleted file mode 100644 index 4e8f218..0000000 --- a/Tools/XlsToCsv/test/timeformat.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/twolettercolumns.csv b/Tools/XlsToCsv/test/twolettercolumns.csv deleted file mode 100644 index c9e3abb..0000000 --- a/Tools/XlsToCsv/test/twolettercolumns.csv +++ /dev/null @@ -1,2 +0,0 @@ -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 Binary files differdeleted file mode 100644 index b25cbff..0000000 --- a/Tools/XlsToCsv/test/twolettercolumns.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/utf8.csv b/Tools/XlsToCsv/test/utf8.csv deleted file mode 100644 index 2b4212b..0000000 --- a/Tools/XlsToCsv/test/utf8.csv +++ /dev/null @@ -1,5 +0,0 @@ -สวัสดี ครับ,Thai language -こんにちは,Japanese language -Здравствуйте,Russian language -नमस्ते,Hindi -السلام عليكم,Arabic diff --git a/Tools/XlsToCsv/test/utf8.xlsx b/Tools/XlsToCsv/test/utf8.xlsx Binary files differdeleted file mode 100644 index 509d5e4..0000000 --- a/Tools/XlsToCsv/test/utf8.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/variousdelim.csv b/Tools/XlsToCsv/test/variousdelim.csv deleted file mode 100644 index 10e5ae3..0000000 --- a/Tools/XlsToCsv/test/variousdelim.csv +++ /dev/null @@ -1 +0,0 @@ -! 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 Binary files differdeleted file mode 100644 index fc2382b..0000000 --- a/Tools/XlsToCsv/test/variousdelim.xlsx +++ /dev/null diff --git a/Tools/XlsToCsv/test/xlsx2csv-test-file.csv b/Tools/XlsToCsv/test/xlsx2csv-test-file.csv deleted file mode 100644 index ec474c4..0000000 --- a/Tools/XlsToCsv/test/xlsx2csv-test-file.csv +++ /dev/null @@ -1,44 +0,0 @@ -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 Binary files differdeleted file mode 100644 index 828cfd7..0000000 --- a/Tools/XlsToCsv/test/xlsx2csv-test-file.xlsx +++ /dev/null |