XML 格式的 Excel 工作簿无法从 SharePoint 打开

本文由支持升级工程师 Warren Rath 撰写。

症状

尝试从 SharePoint 文档库以 XML 格式 (XML Spreadsheet 2003) 打开 Microsoft Excel 工作簿时,会收到以下错误:

无法执行此操作,因为 Office 无法识别给定的命令。

解决方法

若要解决此问题,请根据 Office 的版本和内部版本使用以下注册表项:

警告

如果编辑注册表未完成属性,可能会产生有害的副作用,因此使用此解决方法的风险自担。

32 位 Office 2013 (Microsoft Installer)

[HKEY_CLASSES_ROOT.xml\OpenWithList\excel.exe]

@=""

[HKEY_CLASSES_ROOT\Applications\excel.exe\shell\edit\command]

@=“”C:\Program Files (x86) \Microsoft Office\Office15\EXCEL.EXE“ /n ”%1“”

[HKEY_CLASSES_ROOT\Applications\excel.exe\SupportedTypes]

“.xml”=“”

32 位 Office 2016 (Microsoft Installer)

[HKEY_CLASSES_ROOT.xml\OpenWithList\excel.exe]

@=""

[HKEY_CLASSES_ROOT\Applications\excel.exe\shell\edit\command]

@=“”C:\Program Files\Microsoft Office\Office16\EXCEL.EXE“ /n ”%1“”

[HKEY_CLASSES_ROOT\Applications\excel.exe\SupportedTypes]

“.xml”=“”

64 位 Office 2016 (Microsoft Installer)

[HKEY_CLASSES_ROOT.xml\OpenWithList\excel.exe]

@=""

[HKEY_CLASSES_ROOT\Applications\excel.exe\shell\edit\command]

@=“”C:\Program Files\Microsoft Office\Office16\EXCEL.EXE“ /n ”%1“”

[HKEY_CLASSES_ROOT\Applications\excel.exe\SupportedTypes]

“.xml”=“”

32 位 Office 2016 (即点即用)

[HKEY_CLASSES_ROOT\Applications\Excel.exe]

“FriendlyAppName”=“@C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX86\Microsoft Shared\Office16\oregres.dll,-206”

[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell]

[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell\edit]

@=“@C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX86\Microsoft Shared\Office16\oregres.dll,-1”

[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell\edit\command]

@=“”C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE“ /n ”%1“”

[HKEY_CLASSES_ROOT\Applications\Excel.exe\SupportedTypes]

“.xml”=“”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Applications\excel.exe\shell\edit\command]

@=“”C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE“ /n ”%1“”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Applications\excel.exe\SupportedTypes]

“.xml”=“”

[HKEY_CLASSES_ROOT.xml\OpenWithList\Excel.exe]

@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes.xml\OpenWithList\excel.exe]

@=""

64 位 Office 2016 (即点即用)

[HKEY_CLASSES_ROOT.xml\OpenWithList\Excel.exe]

@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes.xml\OpenWithList\excel.exe]

@=""

[HKEY_CLASSES_ROOT\Applications\Excel.exe]

“FriendlyAppName”=“@C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\Office16\oregres.dll,-206”

[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell]

[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell\edit]

@=“@C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\Office16\oregres.dll,-1”

[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell\edit\command]

@=“”C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE“ /n ”%1“”

[HKEY_CLASSES_ROOT\Applications\Excel.exe\SupportedTypes]

“.xml”=“”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Applications\excel.exe\shell\edit\command]

@=“”C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE“ /n ”%1“”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Applications\excel.exe\SupportedTypes]

“.xml”=“”