1. 问题
- 使用SAP导出Excel后打开Excel时,弹窗提示:"xxx"的文件格式和扩展名不匹配。文件可能已损坏或不安全。除非您信任其来源,否则请勿打开。是否仍要打开它?
![1](https://i-blog.csdnimg.cn/blog_migrate/d94ae1e40f779e3b2bf0b428eea569cf.png)
2. 解决方法(适配版本Office2000-Office2019 & Office 365)
Windows Registry Editor Version 5.00
For Office 2003
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\11.0\Excel\Security]
"ExtensionHardening"=dword:00000000
;For Office 2007
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\12.0\Excel\Security]
"ExtensionHardening"=dword:00000000
;For Office 2010
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Excel\Security]
"ExtensionHardening"=dword:00000000
;For Office 2013
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\15.0\Excel\Security]
"Extens