[求助][已解决]cx_Freeze无法找到模块openpyxl

stanley_tam

求各位大神

1. import sys
   
2. from cx_Freeze import setup, Executable
   
3. 
   
4. executables = [
   
5.         Executable("pyvalidate.py")
   
6.         # Executable("advanced_2.py")
   
7. ]
   
8. 
   
9. buildOptions = dict(
   
10.         compressed = True,
    
11.         includes = ["openpyxl", "os", "re", "sys"],
    
12.         path = sys.path + ["dist"])
    
13. 
    
14. setup(
    
15.         name = "pyvalidate",
    
16.         version = "0.1",
    
17.         description = "sample cx_Freeze script",
    
18.         options = dict(build_exe = buildOptions),
    
19.         executables = executables)
    
20. 
    
21. 上面是setup.py里面的内容，运行python setup.py bdist_msi：
    
22. C:\Users\IBM_ADMIN\Desktop\revalidate>python setup.py bdist_msi
    
23. running bdist_msi
    
24. running build
    
25. running build_exe
    
26. Traceback (most recent call last):
    
27.   File "setup.py", line 19, in <module>
    
28.     executables = executables)
    
29.   File "C:\Python33\lib\site-packages\cx_Freeze\dist.py", line 365, in setup
    
30.     distutils.core.setup(**attrs)
    
31.   File "C:\Python33\lib\distutils\core.py", line 148, in setup
    
32.     dist.run_commands()
    
33.   File "C:\Python33\lib\distutils\dist.py", line 929, in run_commands
    
34.     self.run_command(cmd)
    
35.   File "C:\Python33\lib\distutils\dist.py", line 948, in run_command
    
36.     cmd_obj.run()
    
37.   File "C:\Python33\lib\site-packages\cx_Freeze\windist.py", line 363, in run
    
38.     self.run_command('build')
    
39.   File "C:\Python33\lib\distutils\cmd.py", line 313, in run_command
    
40.     self.distribution.run_command(command)
    
41.   File "C:\Python33\lib\distutils\dist.py", line 948, in run_command
    
42.     cmd_obj.run()
    
43.   File "C:\Python33\lib\distutils\command\build.py", line 126, in run
    
44.     self.run_command(cmd_name)
    
45.   File "C:\Python33\lib\distutils\cmd.py", line 313, in run_command
    
46.     self.distribution.run_command(command)
    
47.   File "C:\Python33\lib\distutils\dist.py", line 948, in run_command
    
48.     cmd_obj.run()
    
49.   File "C:\Python33\lib\site-packages\cx_Freeze\dist.py", line 235, in run
    
50.     freezer.Freeze()
    
51.   File "C:\Python33\lib\site-packages\cx_Freeze\freezer.py", line 570, in Freeze
    
52. 
    
53.     self.finder = self._GetModuleFinder()
    
54.   File "C:\Python33\lib\site-packages\cx_Freeze\freezer.py", line 323, in _GetMo
    
55. duleFinder
    
56.     finder.IncludeModule(name)
    
57.   File "C:\Python33\lib\site-packages\cx_Freeze\finder.py", line 526, in Include
    
58. Module
    
59.     namespace = namespace)
    
60.   File "C:\Python33\lib\site-packages\cx_Freeze\finder.py", line 274, in _Import
    
61. Module
    
62.     raise ImportError("No module named %r" % name)
    
63. ImportError: No module named 'openpyxl'
    
64. 
    
65. 提示木有模块openpyxl...
    
66. openpyxl在python33目录下是.egg的形式
    
67. 
    
68. C:\Python33\Lib\site-packages\openpyxl-1.6.2-py3.3.egg
    

复制代码

remyzane

openpyxl-1.6.2-py3.3.egg目录内有什么子目录和文件？
有 openpyxl 子目录吗，openpyxl子目录下有 __init__.py 文件吗？

lvxinzhi

用pyinstall吧，这个简单更方便

icymirror

回复 1# stanley_tam

C:\Python33\Lib\site-packages\openpyxl-1.6.2-py3.3.egg 实际上是 zip 文件。
Python使用 zlib 来对 .egg (实际上的 zip ) 文件进行类似于基于路径的包管理。

所以，你可以：
1. 把 egg 改扩展名为 zip
2. 解压看下里面有没有所需要的模块、文件名

stanley_tam

谢谢大神帮忙，把egg文件解压缩。问题即解决。
回复 4# icymirror


   

stanley_tam

谢谢，有时间试试回复 3# lvxinzhi


   

stanley_tam

谢谢回复，问题已解决回复 2# remyzane