Skip to content

Error when opening XLSX files in datawrangler #656

@That-Ruben

Description

@That-Ruben

I get this error when trying to open any XLSX file

SyntaxError: Missing parentheses in call to 'print'. Did you mean print(...)? (__init__.py, line 1187)
Traceback (most recent call last):

  File ~\AppData\Roaming\Python\Python312\site-packages\IPython\core\interactiveshell.py:3701 in run_code
    exec(code_obj, self.user_global_ns, self.user_ns)

  Cell In[0], line 2
    df = pd.read_excel(r'c:\Coinpanda\futures-position-20251118-20260118_0_.xlsx')

  File c:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\pandas\io\excel\_base.py:495 in read_excel
    io = ExcelFile(

  File c:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\pandas\io\excel\_base.py:1537 in __init__
    if import_optional_dependency("xlrd", errors="ignore") is None:

  File c:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\pandas\compat\_optional.py:135 in import_optional_dependency
    module = importlib.import_module(name)

  File c:\Users\User\AppData\Local\Programs\Python\Python312\Lib\importlib\__init__.py:90 in import_module
    return _bootstrap._gcd_import(name[level:], package, level)

  File <frozen importlib._bootstrap>:1387 in _gcd_import

  File <frozen importlib._bootstrap>:1360 in _find_and_load

  File <frozen importlib._bootstrap>:1331 in _find_and_load_unlocked

  File <frozen importlib._bootstrap>:935 in _load_unlocked

  File <frozen importlib._bootstrap_external>:991 in exec_module

  File <frozen importlib._bootstrap_external>:1129 in get_code

  File <frozen importlib._bootstrap_external>:1059 in source_to_code

  File <frozen importlib._bootstrap>:488 in _call_with_frames_removed

  File c:\Users\User\AppData\Local\Programs\Python\Python312\Lib\site-packages\xlrd\__init__.py:1187
    print "EXTERNSHEET(b7-):"
    ^
SyntaxError: Missing parentheses in call to 'print'. Did you mean print(...)?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions