天天看點
傳回

python win32com Dispatch, DispatchEx 無法打開(啟動)excel pywintypes.com_error: (-2146959355, ‘伺服器運作失敗‘

最近換了個硬碟，重裝電腦後，想用python打開excel，發現完全沒反應，彈出以下錯誤資訊：

asctime:        Sun, 02 May 2021 12:48:36 
bug_line:       line:509 
level:          ERROR 
message:        ERROR：(-2146959355, '伺服器運作失敗', None, None)
Traceback (most recent call last):
  File "D:\Python\Python38\lib\site-packages\win32com\client\dynamic.py", line 81, in _GetGoodDispatch
    IDispatch = pythoncom.connect(IDispatch)
pywintypes.com_error: (-2147221021, '操作無法使用', None, None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "F:/發送房租軟體/begin.py", line 503, in open_excel
    send_info_dict,fangzi_shuidian=open_excel.get_send_info()
  File "F:/發送房租軟體/begin.py", line 184, in get_send_info
    month_info,shuidian_dict=self.get_all_info()  #擷取所有租戶所選月份對應的所有具體租金、水電量
  File "F:/發送房租軟體/begin.py", line 177, in get_all_info
    self.creat_next_month(file)#提前建立目前月份/下個月的資料
  File "F:/發送房租軟體/begin.py", line 215, in creat_next_month
    excel = Dispatch('excel.application')  # 建立Excel對象
  File "D:\Python\Python38\lib\site-packages\win32com\client\__init__.py", line 95, in Dispatch
    dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
  File "D:\Python\Python38\lib\site-packages\win32com\client\dynamic.py", line 98, in _GetGoodDispatchAndUserName
    return (_GetGoodDispatch(IDispatch, clsctx), userName)
  File "D:\Python\Python38\lib\site-packages\win32com\client\dynamic.py", line 83, in _GetGoodDispatch
    IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.IID_IDispatch)
pywintypes.com_error: (-2146959355, '伺服器運作失敗', None, None)

期間下載下傳了wps，以為是這個問題，不斷重裝excel跟wps，發現還是不行！！

百度了一番，基本是2個說法 

1.權限問題，python跟excel不是同一個權限------------------------------試來試去，都是用管理者授權了，還是不行

2.Excel.Application注冊資訊不對，是以pywin32無法調用

針對注冊的說法，可以參考下這個老哥https://blog.csdn.net/l490134872/article/details/80250395

思路是對了，不過我在系統資料庫查詢時，發現有好幾個Microsoft Excel Application，程式ID也是對得上的（注意在系統資料庫搜尋時，它的比對方式是全字比對！）

是以得把它全改了才行！！！

太費勁了，是以我想，要不直接 通過系統資料庫在dcom配置中重建excel應用程式 ！！

參考這篇文章，具體内容我也貼上來了https://jingyan.baidu.com/article/14bd256e79a67dbb6d261299.html

  1. 打開記事本，把下列系統資料庫代碼複制到記事本中。 
  2. Windows Registry Editor Version 5.00


[HKEY_CLASSES_ROOT\AppID\{00020820-0000-0000-C000-000000000046}]

@="Microsoft Office Excel 97-2003 工作表"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}]

"IPersistStorageType"=dword:00000002

@="Microsoft Office Excel 97-2003 工作表"

"AppID"="{00020820-0000-0000-C000-000000000046}"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\AuxUserType]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\AuxUserType\2]

@="Worksheet"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\AuxUserType\3]

@="Microsoft Office Excel 2003"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readable]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readable\Main]

@="Biff8,ExcelWorksheet,ExcelML12,Biff12"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readwritable]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readwritable\Main]

@="Biff8,ExcelML12,Biff12"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\DefaultFile]

@="Biff8"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\0]

@="3,1,32,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\1]

@="2,1,16,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\2]

@="1,1,1,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\3]

@="NotesDocInfo,1,1,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\4]

@="NoteshNote,-1,1,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DefaultExtension]

@=".xls, Excel Workbook (*.xls)"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DefaultIcon]

@="C:\\Windows\\Installer\\{90120000-0011-0000-0000-0000000FF1CE}\\xlicons.exe,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DocObject]

@="16"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Implemented Categories]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Implemented Categories\{000C0118-0000-0000-C000-000000000046}]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\InprocHandler32]

@="ole32.dll"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\InprocServer32]

"Assembly"="Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"

"Class"="Microsoft.Office.Interop.Excel.WorksheetClass"

"RuntimeVersion"="v1.1.4322"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\InprocServer32\12.0.0.0]

"Assembly"="Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"

"Class"="Microsoft.Office.Interop.Excel.WorksheetClass"

"RuntimeVersion"="v1.1.4322"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Insertable]

@=""


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\LocalServer]

@="C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE"

"LocalServer"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,\

  00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,\

  43,00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,\

  00,24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,\

  61,00,54,00,4f,00,35,00,00,00,00,00


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\LocalServer32]

@="C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE"

"LocalServer32"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,\

  21,00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,\

  00,43,00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,\

  7e,00,24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,\

  00,61,00,54,00,4f,00,35,00,00,00,00,00


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\MiscStatus]

@="32"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\PersistentHandler]

@="{98de59a0-d175-11cd-a7bd-00006b827d94}"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Printable]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\ProgID]

@="Excel.Sheet.8"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Typelib]

@="{00020813-0000-0000-C000-000000000046}"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Verb]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Verb\0]

@="編輯(&E),0,2"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Verb\1]

@="打開(&O),0,2"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Version]

@="1.2"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}]

"IPersistStorageType"=dword:00000002

@="Microsoft Office Excel 97-2003 工作表"

"AppID"="{00020820-0000-0000-C000-000000000046}"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\AuxUserType]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\AuxUserType\2]

@="Worksheet"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\AuxUserType\3]

@="Microsoft Office Excel 2003"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readable]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readable\Main]

@="Biff8,ExcelWorksheet,ExcelML12,Biff12"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readwritable]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readwritable\Main]

@="Biff8,ExcelML12,Biff12"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\DefaultFile]

@="Biff8"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\0]

@="3,1,32,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\1]

@="2,1,16,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\2]

@="1,1,1,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\3]

@="NotesDocInfo,1,1,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\4]

@="NoteshNote,-1,1,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DefaultExtension]

@=".xls, Excel Workbook (*.xls)"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DefaultIcon]

@="C:\\Windows\\Installer\\{90120000-0011-0000-0000-0000000FF1CE}\\xlicons.exe,1"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\DocObject]

@="16"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Implemented Categories]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Implemented Categories\{000C0118-0000-0000-C000-000000000046}]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\InprocHandler32]

@="ole32.dll"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\InprocServer32]

"Assembly"="Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"

"Class"="Microsoft.Office.Interop.Excel.WorksheetClass"

"RuntimeVersion"="v1.1.4322"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\InprocServer32\12.0.0.0]

"Assembly"="Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"

"Class"="Microsoft.Office.Interop.Excel.WorksheetClass"

"RuntimeVersion"="v1.1.4322"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Insertable]

@=""


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\LocalServer]

@="C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE"

"LocalServer"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,\

  00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,\

  43,00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,\

  00,24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,\

  61,00,54,00,4f,00,35,00,00,00,00,00


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\LocalServer32]

@="C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE"

"LocalServer32"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,\

  21,00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,\

  00,43,00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,\

  7e,00,24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,\

  00,61,00,54,00,4f,00,35,00,00,00,00,00


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\MiscStatus]

@="32"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\PersistentHandler]

@="{98de59a0-d175-11cd-a7bd-00006b827d94}"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Printable]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\ProgID]

@="Excel.Sheet.8"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Typelib]

@="{00020813-0000-0000-C000-000000000046}"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Verb]


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Verb\0]

@="編輯(&E),0,2"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Verb\1]

@="打開(&O),0,2"


[HKEY_CLASSES_ROOT\CLSID\{00020820-0000-0000-C000-000000000046}\Version]

@="1.2"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AppID\{00020820-0000-0000-C000-000000000046}]

@="Microsoft Office Excel 97-2003 工作表"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}]

"IPersistStorageType"=dword:00000002

@="Microsoft Office Excel 97-2003 工作表"

"AppID"="{00020820-0000-0000-C000-000000000046}"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\AuxUserType]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\AuxUserType\2]

@="Worksheet"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\AuxUserType\3]

@="Microsoft Office Excel 2003"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readable]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readable\Main]

@="Biff8,ExcelWorksheet,ExcelML12,Biff12"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readwritable]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Conversion\Readwritable\Main]

@="Biff8,ExcelML12,Biff12"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\DefaultFile]

@="Biff8"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\0]

@="3,1,32,1"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\1]

@="2,1,16,1"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\2]

@="1,1,1,1"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\3]

@="NotesDocInfo,1,1,1"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DataFormats\GetSet\4]

@="NoteshNote,-1,1,1"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DefaultExtension]

@=".xls, Excel Workbook (*.xls)"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DefaultIcon]

@="C:\\Windows\\Installer\\{90120000-0011-0000-0000-0000000FF1CE}\\xlicons.exe,1"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\DocObject]

@="16"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Implemented Categories]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Implemented Categories\{000C0118-0000-0000-C000-000000000046}]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\InprocHandler32]

@="ole32.dll"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\InprocServer32]

"Assembly"="Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"

"Class"="Microsoft.Office.Interop.Excel.WorksheetClass"

"RuntimeVersion"="v1.1.4322"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\InprocServer32\12.0.0.0]

"Assembly"="Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"

"Class"="Microsoft.Office.Interop.Excel.WorksheetClass"

"RuntimeVersion"="v1.1.4322"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Insertable]

@=""


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\LocalServer]

@="C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE"

"LocalServer"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,\

  00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,\

  43,00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,\

  00,24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,\

  61,00,54,00,4f,00,35,00,00,00,00,00


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\LocalServer32]

@="C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE"

"LocalServer32"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,\

  21,00,21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,\

  00,43,00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,\

  7e,00,24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,\

  00,61,00,54,00,4f,00,35,00,00,00,00,00


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\MiscStatus]

@="32"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\PersistentHandler]

@="{98de59a0-d175-11cd-a7bd-00006b827d94}"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Printable]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\ProgID]

@="Excel.Sheet.8"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Typelib]

@="{00020813-0000-0000-C000-000000000046}"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Verb]


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Verb\0]

@="編輯(&E),0,2"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Verb\1]

@="打開(&O),0,2"


[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{00020820-0000-0000-C000-000000000046}\Version]

@="1.2"
  3. 然後在記事本中，用替換把裡面的EXCEL路徑替換為你電腦對應的EXCEL所在路徑，目前路徑為C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE  如果一樣就不用改動，直接另存為Excel應用.reg。注意檔案擴充名為reg。
  4. 輕按兩下執行Excel應用.reg，導入系統資料庫資訊。
    python win32com Dispatch, DispatchEx 無法打開(啟動)excel pywintypes.com_error: (-2146959355, ‘伺服器運作失敗‘
  5. 完成導入。重新開機電腦。
    python win32com Dispatch, DispatchEx 無法打開(啟動)excel pywintypes.com_error: (-2146959355, ‘伺服器運作失敗‘
  6. 再進入dcomcnfg元件 DCOM配置，我安裝的是32位的excel，是以實際改變路徑的是
    python win32com Dispatch, DispatchEx 無法打開(啟動)excel pywintypes.com_error: (-2146959355, ‘伺服器運作失敗‘

後面就可以成功啟動excel了！！！

疑難雜症
上一篇: 部署web項目在linux伺服器需要注意的一些問題
下一篇: AD域系統安全防護中組政策的應用随着網際網路技術的飛速發展，企業資訊化建設越來越普遍，企業對于網絡安全的需求也越來越高。其

繼續閱讀