Excel primary interop assembly is not found

2019 7 24
1 个回答
回答已采纳
更新时间：2019 7 24
4 次查看（30 天）

0 个投票

when i package the "deployable archive with excel integration" ,i get the error below:
"Excel primary interop assembly is not found. Install Visual Studio Office Developer tools. These tools are usually installed during a standard Visual Studio installation."
but i have installed the "office/sharepoint development " component,which includes "office developer tools for visual studio". i try from visual studio 2017 to 2019,it just doesn't work,i can't figure out why.please help me,thank you.

请先登录，再回答此问题。

 采纳的回答

weixun yan
weixun yan 2019-7-24

0 个投票

https://www.mathworks.com/matlabcentral/answers/179296-why-do-i-receive-excel-primary-interop-assembly-is-not-found-error-when-creating-excel-add-in-clie#comment_621619
this works for me

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

weixun yan
weixun yan 2019-7-24
for VS 2017 and Office 2016, you can try to copy
C:\Program Files (x86)\Microsoft Office\root\Office16\ADDINS\Microsoft Power Query for Excel Integrated\bin\Microsoft.Office.Interop.Excel.dll
TO:
C:\Program Files (x86)\Microsoft Visual Studio 12.0\Visual Studio Tools for Office\PIA\Office15
Create the path if doesn't exist

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

产品

版本

R2019a

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by