dfujim
commented
5 years ago This is also a file load issue, related to formatting of the file. If you highlight all and "Clear Direct Formatting" then it works.
Open cbevington opened 5 years ago
dfujim
commented
5 years ago This is also a file load issue, related to formatting of the file. If you highlight all and "Clear Direct Formatting" then it works.
Traceback and the spreadsheet in question are below:
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/descriptors/base.py", line 57, in _convert value = expected_type(value) ValueError: could not convert string to float: '"<=0"'
During handling of the above exception, another exception occurred:
Traceback (most recent call last): File "/usr/lib/python3.5/runpy.py", line 184, in _run_module_as_main "main", mod_spec) File "/usr/lib/python3.5/runpy.py", line 85, in _run_code exec(code, run_globals) File "/home/connor/.local/lib/python3.5/site-packages/compsheet/main.py", line 119, in
c.compare(options=args.options,do_print=args.full,do_verbose=args.verbose)
File "/home/connor/.local/lib/python3.5/site-packages/compsheet/multifile_comparer.py", line 223, in compare
self._compare(map,cm,do_verbose)
File "/home/connor/.local/lib/python3.5/site-packages/compsheet/multifile_comparer.py", line 196, in _compare
for i,c in tqdm(enumerate(mapfn(compare_fn,self.comparers)),total=ncompare):
File "/home/connor/.local/lib/python3.5/site-packages/tqdm/_tqdm.py", line 1002, in iter
for obj in iterable:
File "/home/connor/.local/lib/python3.5/site-packages/compsheet/multifile_comparer.py", line 507, in do_compare
c.compare(options=options,do_print=do_print)
File "/home/connor/.local/lib/python3.5/site-packages/compsheet/comparer.py", line 343, in compare
self.load()
File "/home/connor/.local/lib/python3.5/site-packages/compsheet/comparer.py", line 481, in load
self.book2 = openpyxl.load_workbook(self.file2)
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/reader/excel.py", line 250, in load_workbook
ws_parser.parse()
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/reader/worksheet.py", line 130, in parse
dispatchertag_name
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/reader/worksheet.py", line 296, in parser_conditional_formatting
cf = ConditionalFormatting.from_tree(element)
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/descriptors/serialisable.py", line 84, in from_tree
obj = desc.expected_type.from_tree(el)
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/descriptors/serialisable.py", line 100, in from_tree
return cls(**attrib)
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/formatting/rule.py", line 60, in init
self.val = val
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/formatting/rule.py", line 39, in set
super(ValueDescriptor, self).set(instance, value)
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/descriptors/base.py", line 69, in set
value = _convert(self.expected_type, value)
File "/home/connor/.local/lib/python3.5/site-packages/openpyxl/descriptors/base.py", line 59, in _convert
raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'float'>