summaryrefslogtreecommitdiff
path: root/test_tablib.py
diff options
context:
space:
mode:
Diffstat (limited to 'test_tablib.py')
-rwxr-xr-xtest_tablib.py19
1 files changed, 19 insertions, 0 deletions
diff --git a/test_tablib.py b/test_tablib.py
index 758ac91..bff3147 100755
--- a/test_tablib.py
+++ b/test_tablib.py
@@ -782,6 +782,25 @@ class TSVTests(BaseTestCase):
self.assertEqual(tsv, self.founders.tsv)
+class XLSXTests(BaseTestCase):
+ def test_xlsx_import_set(self):
+ data.append(('string', 42, 21.55))
+ data.headers = ('string', 'integer', 'float')
+ _xlsx = data.xlsx
+ data.xlsx = _xlsx
+ self.assertEqual(data.dict[0]['string'], 'string')
+ self.assertEqual(data.dict[0]['integer'], 42)
+ self.assertEqual(data.dict[0]['float'], 21.55)
+
+ def test_xlsx_wrong_char(self):
+ """Bad characters are not silently ignored. We let the exception bubble up."""
+ from openpyxl.utils.exceptions import IllegalCharacterError
+
+ with self.assertRaises(IllegalCharacterError):
+ data.append(('string', b'\x0cf'))
+ data.xlsx
+
+
class JSONTests(BaseTestCase):
def test_json_format_detect(self):
"""Test JSON format detection."""