Excel Visual Studio 设计时适配器加载项错误
我正在尝试使用 VSTO 打开 Excel 工作簿 2003。 但我再次收到错误,例如
“无法创建项目,因为应用程序加载项无法正常工作并且可能已被禁用。要检查 Microsoft Office 应用程序中的禁用项目,请打开“帮助”菜单,单击“关于 Microsoft Office Word”或关于 Microsoft Office Excel,然后单击禁用项目 如果出现“Word Visual Studio 设计时适配器加载项”或“Excel Visual Studio 设计时适配器加载项”,请选择它并单击启用。如果没有,请重新安装或。修复 Visual Studio Tools for Office 的安装。”
有人可以帮忙吗?
I am trying to open excel workbook 2003 using VSTO.
but i am getting error again again like
" Project cannot be created because the application add-in is not working correctly and might have been disabled. To check for disabled items in the Microsoft Office application, open the Help menu, click About Microsoft Office Word or About Microsoft Office Excel, and then click Disabled Items. If either "Word Visual Studio Design Time Adapter Add-in" or "Excel Visual Studio Design Time Adapter Add-in" appears, select it and click Enable. If not, reinstall or repair your installation of Visual Studio Tools for Office."
Can somebody help ??
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
在某些情况下,您只需关闭 EXCEL.exe,使其不再与 TaskManager 一起运行。
我遇到了同样的问题,现在可以了。
In some cases you just have to close EXCEL.exe from running with TaskManager.
I had the same issue and now it works.
也许这与我使用 VSTO 时遇到的设计时适配器错误相同的问题
正如所建议的,在修复安装之前,我快速检查了任务管理器,并注意到 Excel.exe 进程仍在运行。结束了这个过程,嘿,很快,问题就解决了。
有时,在调试/运行项目时,如果项目在代码关闭 Excel 应用程序之前失败或停止,则设计时适配器会挂起。这发生在我身上,因为 Automation Excetuable 留下了一个 Excel 实例并在visible = false 模式下运行。
Maybe this is the same problem I was having with Design Time Adapter errors using VSTO
Just before repairing the install, as is advised, I had a quick check of the Task Manager, and noticed that an Excel.exe process was still running. Ended this process, and hey presto, it fixed the problem.
It appears that sometimes when debugging/running your project, if it fails or stops before the Excel app gets closed by your code, the design time adaptor hangs. This happened to me because an Automation Excetuable had left an instance of Excel up and running in visible = false mode.
我来自未来,2020 年,但尽管使用 Office 365、Windows 10 和 Visual Studio 2019,我还是遇到了同样的问题。Visual Studio 设计时适配器加载项(在我的例子中是 Excel,但这几乎不相关) ) 每次重新启动 Excel 后都会不断禁用自身。
重新安装 VSTO 组件没有帮助,我不想弄乱整个 Office/VS 重新安装。
通过将注册表中的 HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\VS15ExcelAdaptor 项的值从 0 更改为 3 解决了该问题>。
I am from the future, year of 2020, but I had the same issue despite using Office 365, Windows 10, and Visual Studio 2019. Visual Studio Design-Time Adapter Add-in (in my case it was Excel, but that's hardly relevant) kept disabling itself after each restart of Excel.
Reinstalling VSTO components didn't help, and I did not want to mess with the whole Office/VS re-installation.
The problem was solved by changing the value of HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\VS15ExcelAdaptor key in the registry from 0 to 3.