Auto Py To Exe fail to find hidden import package

[yijuchenwork1113]

I'm packaging my code to a complied exe file using auto py to exe, however I found this error below when running the exe file:

pyexcel_io.writers is absent or cannot be imported
Traceback (most recent call last):
File "lml\utils.py", line 42, in do_import
File "lml\utils.py", line 49, in _do_import
ModuleNotFoundError: No module named 'pyexcel_io.writers'

Therefore, I checked the output code in the auto-py-to-exe that might be the cause of this error:
80789 INFO: PyInstaller: 5.13.2
80795 INFO: Python: 3.9.7
329021 WARNING: Hidden import "pyexcel_io.readers.csvr" not found!
329073 WARNING: Hidden import "pyexcel_io.readers.tsv" not found!
329087 WARNING: Hidden import "pyexcel_io.readers.tsvz" not found!
329419 WARNING: Hidden import "pyexcel_io.writers.csvw" not found!
329436 WARNING: Hidden import "pyexcel_io.writers.csvz" not found!
329439 WARNING: Hidden import "pyexcel_io.writers.tsv" not found!
329453 WARNING: Hidden import "pyexcel_io.writers.tsvz" not found!
329469 WARNING: Hidden import "pyexcel_io.readers.tsv" not found!
329483 WARNING: Hidden import "pyexcel_io.readers.tsvz" not found!

I'm using the virtual environment (venv) and I'm pretty sure I installed all the packages using the pycharm terminal, and I also executed auto py to exe here. I've tried adding --path and --hidden import in to the pyinstaller commend but still get the hidden import not found error. I also checked the sitepackages folder and the auto-py-to-exe, pyexcel-iso, pyinstaller packages are all in that folder. Could anyone provide any insight about this? Thank you!