ValueError: could not convert string to float: '*leeg*'

[Sathish Kumar]

Hi All,

Good day!!

I have created a python script to update the excel worksheets and able to run it on the sample excel template on my windows environment with Python 3.9.6.

When I am trying to execute the same code with same excel template I am getting below error on linux environment with same version of python 3.9.6

Can anyone advise me what can be done.

Thanks and Regards,

Sathish.

/usr/local/lib/python3.9/site-packages/openpyxl/worksheet/_reader.py:315: UserWarning: Data Validation extension is not supported and will be removed

  warn(msg)

/usr/local/lib/python3.9/site-packages/openpyxl/worksheet/_reader.py:315: UserWarning: Slicer List extension is not supported and will be removed

  warn(msg)

Traceback (most recent call last):

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/base.py", line 55, in _convert

    value = expected_type(value)

ValueError: could not convert string to float: '*leeg*'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

  File "/webdav/sc_py/update_siebel_check_excel.py", line 30, in <module>

    workbook = load_workbook(filename=folder_path + '/' + excel_template_name, read_only=False)

  File "/usr/local/lib/python3.9/site-packages/openpyxl/reader/excel.py", line 322, in load_workbook

    reader.read()

  File "/usr/local/lib/python3.9/site-packages/openpyxl/reader/excel.py", line 287, in read

    self.read_worksheets()

  File "/usr/local/lib/python3.9/site-packages/openpyxl/reader/excel.py", line 273, in read_worksheets

    pivot = TableDefinition.from_tree(tree)

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/serialisable.py", line 83, in from_tree

    obj = desc.from_tree(el)

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/sequence.py", line 85, in from_tree

    return [self.expected_type.from_tree(el) for el in node]

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/sequence.py", line 85, in <listcomp>

    return [self.expected_type.from_tree(el) for el in node]

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/serialisable.py", line 87, in from_tree

    obj = desc.expected_type.from_tree(el)

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/serialisable.py", line 87, in from_tree

    obj = desc.expected_type.from_tree(el)

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/serialisable.py", line 87, in from_tree

    obj = desc.expected_type.from_tree(el)

  [Previous line repeated 1 more time]

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/serialisable.py", line 103, in from_tree

    return cls(**attrib)

  File "/usr/local/lib/python3.9/site-packages/openpyxl/worksheet/filters.py", line 163, in __init__

    self.val = val

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/base.py", line 67, in __set__

    value = _convert(self.expected_type, value)

  File "/usr/local/lib/python3.9/site-packages/openpyxl/descriptors/base.py", line 57, in _convert

    raise TypeError('expected ' + str(expected_type))

TypeError: expected <class 'float'>

root@roboserver11202-77d74d674f-9ntc6:/tmp/python/Python-3.9.6#

[Sathish Kumar]

Hi All,

I have found that openpyxl version 3.0.8 is giving this error, downgraded to 3.0.7 and its ran without the above error.

Thanks and Regards,

Sathish.

[Haider Asad]

having the same error but not always ,only randomly