Reading xlsx files in py2exe

Question

I am using pyexcel_io.get_data method to read xlsx files for my wxpython application. When I run it with python main.py, reading the file works fine and it reads the contents properly. But when I create an executable using py2exe, the code gets stuck in get_data function, and also no error is thrown. It seems like the code is just stuck inside the get_data function. Googled but could not find any similar occurences of this issue.

Are there any other similar libraries for reading xlsx files? Or is there an existing solution for this issue?

Thanks in advance

Answer 1

You need to tell py2exe about the hidden imports:

pyexcel_xlsx
pyexcel_xlsx.xlsxr
pyexcel_xlsx.xlsxw

Potential solution: Py2Exe and Easgui

People tried with pyinstaller with success.