1、首先,在运行处输入dcomcnfg.exe,进入组件服务,查看当前DCOM配置中是否存在excel应用程序?如果不存在,接下来就要自己重建这个应用。
2、确定电脑中,目前安装的Offi罕铞泱殳ce Excel安装在哪个盘哪个目录下,正确一般在C盘,本人电脑EXCEL揍茏壅混文件所在位置为例C:\Program Files\Microsoft Office\Office12\EXCEL.EXE
3、打开记事本,把下列注册表代码复制到记事本中。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\\Microsoft Office\\Office12\\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\\Microsoft Office\\Office12\\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\\Microsoft Office\\Office12\\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\\Microsoft Office\\Office12\\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\\Microsoft Office\\Office12\\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\\Microsoft Office\\Office12\\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"然后在记事本中,用替换把里面的EXCEL路径替换为你电脑对应的EXCEL所在路径,目前路径为C:\\Program Files\\Microsoft Office\\Office12\\EXCEL.EXE如果一样就不用改动,直接另存为Excel应用.reg。注意文件扩展名为reg。
4、双击执行Excel应用.reg,导入注册表信息。
5、完成导入。重启电脑。
6、运行dcomcnfg.exe,现在就可以查看到相应的EXCEL应用组件了。再打开软件进行EXCEL导出,就不再提示出错,OK了。