win32com无法运行

shenshuai

我想用为win32模块把一个xls文件转换成xlsx文件
这是我的代码：

1. import os
   
2. import win32com.client as win32
   
3. address = address = os.getcwd()
   
4. 
   
5. fname = address + "\\Bundles.xls"
   
6. fname2 = address + "\\searchresults.xls"
   
7. excel = win32.gencache.EnsureDispatch('Excel.Application')
   
8. excel2 = win32.gencache.EnsureDispatch('Excel.Application')
   
9. wb = excel.Workbooks.Open(fname)
   
10. wb5 = excel.Workbooks.Open(fname2)
    
11. 
    
12. wb.SaveAs(fname+"x", FileFormat = 51)
    
13. wb5.SaveAs(fname2+"x", FileFormat = 51)    #FileFormat = 51 is for .xlsx extension
    
14. wb.Close()
    
15. wb5.Close()                               #FileFormat = 56 is for .xls extension
    
16. excel.Application.Quit()
    
17. excel2.Application.Quit()
    
18. print('File .xls convert .xlsx successful!!')

复制代码

这是错误显示：
Traceback (most recent call last):
  File "c:/Users/shenshuaic/Desktop/SFP Program/win32test.py", line 10, in <module>
    import win32com.client as win32
  File "C:\Users\shenshuaic\AppData\Local\Continuum\anaconda3\lib\site-packages\win32com\__init__.py", line 5, in <module>
    import win32api, sys, os
ImportError: DLL load failed: The specified procedure could not be found.

XiaoPaiShen

我运行你的代码没出现问题, 帮你查了一下，试试下面的方法

I have the same problem for days, but one day I solved it.
After you installed the pywin32 libs, there is a directory "Lib/site-packages/pywin32_system32", which including three dll libs, copy them to the "/Lib/site-packages/win32" directory, which including the win32api.pyd or win32api.pyc.
There will be no ImportError Exception any more

默认路径： C:\Users\user_name\AppData\Local\Programs\Python\Python37\Lib\site-packages\pywin32_system32

shenshuai

XiaoPaiShen 发表于 2019-12-12 03:05
我运行你的代码没出现问题, 帮你查了一下，试试下面的方法

I have the same problem for days, but one  ...

哦哦，意思就是把win32api.pyd，或者是win32api.pyc复制到pywin32_system32这个文件夹里嘛？

XiaoPaiShen

shenshuai 发表于 2019-12-12 12:04
哦哦，意思就是把win32api.pyd，或者是win32api.pyc复制到pywin32_system32这个文件夹里嘛？

是pywin32_system32文件夹中的文件复制到wIn32文件夹中