I solved it with a workaround. Since it worked in fresh environment, I created a separate exe with that, to get data from excel and print out. Then in main program i used subprocess to run that excel.exe to get data, converted it to string and modified to convert it into other types I needed. Now I got problem with Oracle library, but that's for probably different topic.
niedziela, 12 grudnia 2021 o 19:11:46 UTC+1 Tomasz Mazowiecki napisał(a): > Hello. Got similar problem with pyinstaller. I made a small gui program > that opens exe file using openpyxl and does some other stuff with that data > but I can't get it to work with exe. > Already tried that solution from above. It works when I create new projekt > with new environment in pycharm, then install pyinstaller in that but when > I tried on my project, it's not working. Then I tried to make new py file > in current project, that only imports openpyxl and same result. > when trying > (venv) PycharmProjects\adnoc_file_compare>PyInstaller test_imoprts.py > it ends with > Unable to find > "pycharmprojects\adnoc_file_compare\venv\lib\site-packages\setuptools-28.8.0-py3.6.egg\EGG-INFO" > > when adding binary and data files. > > > wtorek, 18 sierpnia 2020 o 13:18:17 UTC+2 [email protected] napisał(a): > >> Extra bonus - not only did fixing the venv get rid or the error, but the >> "--hidden-import" option(s) no longer required. :o) >> >> On Tuesday, 18 August 2020 at 10:33:37 UTC+1 bwoodsend wrote: >> >>> Under the hood PyInstaller always uses a spec file. If you use PyInstaller >>> --[some options] script.py it will generate script.spec (overwriting it >>> if one already exists) that contains all your options, then call >>> automatically PyInstaller script.spec. >>> >>> If you want to use the spec to avoid having to list all your options >>> every time (strongly recommended) then just call PyInstaller script.spec >>> which will run it without modifying it. If you want to change your options >>> then you modify the spec (it’s just a Python script). >>> >>> >> -- You received this message because you are subscribed to the Google Groups "PyInstaller" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pyinstaller/a71ea218-a66b-49ca-9908-5963bc30636an%40googlegroups.com.
