blocks|key|225912|text|更新(感谢user2347528)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|225913|这些程序集以NuGet包的形式提供，这比我最初的答案简单得多。|225914|您可以通过右键单击项目中的References并选择Manage+NuGet+packages...并搜索下面列出的包之一进行安装，也可以使用包管理器控制台进行安装：|offset|length|style|BOLD|225915|PM>+Install-Package+Microsoft.Office.Interop.Excel|code-block|syntax|javascript|225916|225917|Microsoft.Office.Interop.Excel|unordered-list-item|225918|Microsoft.Office.Interop.Word|225919|Microsoft.Office.Interop.Outlook|225920|Microsoft.Office.Interop.PowerPoint|225921|Microsoft.Office.Interop.Graph|225922|225923|225924|这些组件以“主互操作程序集”的形式提供，可以与Office一起安装，也可以单独下载和安装。How+to:+Install+Office+Primary+Interop+Assemblies。|225925|安装这些程序集后，您可以在.NET下的Add+reference对话框中的项目中引用它们。如果您没有看到列出的那些Microsoft.Office.Interop程序集，那么它们还没有安装。从您的安装程序中安装它们，或者单独下载并安装它们(请参阅上面的下载链接)。|225926|entityMap|0|LINK|mutability|MUTABLE|url|https://www.nuget.org/packages/Microsoft.Office.Interop.Excel|1|https://www.nuget.org/packages/Microsoft.Office.Interop.Word|2|https://www.nuget.org/packages/Microsoft.Office.Interop.Outlook|3|https://www.nuget.org/packages/Microsoft.Office.Interop.PowerPoint|4|https://www.nuget.org/packages/Microsoft.Office.Interop.Graph|5|http://msdn.microsoft.com/en-us/library/kh3965hw%2528v=vs.100%2529.aspx^0|0|0|D|A|Q|O|0|0|0|0|U|0|0|0|T|1|0|0|W|2|0|0|Z|3|0|0|U|4|0|0|0|19|1D|5|0|0^^$0|@$1|2|3|4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1Q|8|@$F|1R|G|1S|H|I]|$F|1T|G|1U|H|I]]|9|@]|A|$]]|$1|J|3|K|5|L|7|1V|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1X|8|@]|9|@$F|1Y|G|1Z|1|20]]|A|$]]|$1|S|3|T|5|R|7|21|8|@]|9|@$F|22|G|23|1|24]]|A|$]]|$1|U|3|V|5|R|7|25|8|@]|9|@$F|26|G|27|1|28]]|A|$]]|$1|W|3|X|5|R|7|29|8|@]|9|@$F|2A|G|2B|1|2C]]|A|$]]|$1|Y|3|Z|5|R|7|2D|8|@]|9|@$F|2E|G|2F|1|2G]]|A|$]]|$1|10|3|-4|5|6|7|2H|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|2I|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|2J|8|@]|9|@$F|2K|G|2L|1|2M]]|A|$]]|$1|14|3|15|5|6|7|2N|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|2O|8|@]|9|@]|A|$]]]|17|$18|$5|19|1A|1B|A|$1C|1D]]|1E|$5|19|1A|1B|A|$1C|1F]]|1G|$5|19|1A|1B|A|$1C|1H]]|1I|$5|19|1A|1B|A|$1C|1J]]|1K|$5|19|1A|1B|A|$1C|1L]]|1M|$5|19|1A|1B|A|$1C|1N]]]]

<h1>Update (thanks user2347528)</h1>
These assemblies are available as NuGet packages, which is much easier than my original answer.
You can install by either right clicking on References in your project and selecting Manage NuGet packages... and searching for one of the packages listed below, or install using the Package Manager Console:
<pre><code>PM&gt; Install-Package Microsoft.Office.Interop.Excel
</code></pre>
<ul>
<li><a href="https://www.nuget.org/packages/Microsoft.Office.Interop.Excel" rel="noreferrer">Microsoft.Office.Interop.Excel</a></li>
<li><a href="https://www.nuget.org/packages/Microsoft.Office.Interop.Word" rel="noreferrer">Microsoft.Office.Interop.Word</a></li>
<li><a href="https://www.nuget.org/packages/Microsoft.Office.Interop.Outlook" rel="noreferrer">Microsoft.Office.Interop.Outlook</a></li>
<li><a href="https://www.nuget.org/packages/Microsoft.Office.Interop.PowerPoint" rel="noreferrer">Microsoft.Office.Interop.PowerPoint</a></li>
<li><a href="https://www.nuget.org/packages/Microsoft.Office.Interop.Graph" rel="noreferrer">Microsoft.Office.Interop.Graph</a></li>
</ul>
<hr />
These are available as &quot;Primary Interop Assemblies&quot;, which can be installed with Office, or downloaded and installed separately. <a href="http://msdn.microsoft.com/en-us/library/kh3965hw%28v=vs.100%29.aspx" rel="noreferrer">How to: Install Office Primary Interop Assemblies</a>.
Once those are installed, you can reference them in your project in the Add Reference dialog, under .NET. If you do not see those Microsoft.Office.Interop assemblies listed, then they have not been installed yet. Install them from your setup, or download and install them separately (see my link above for the downloads).

blocks|key|2885603|text|如果您安装了Microsoft+Office，那么您应该能够添加对Interop.Excel的引用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2885604|例如，我正在输入的PC上安装了MSVS2010+C#+Express和Office2010。我可以添加对Microsoft.Office.Interop.Excel+11.0.0.0的引用。|2885605|“希望这能有所帮助。|2885606|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

If you have Microsoft Office installed, then you should be able to add a reference to Interop.Excel.

For example, the PC I'm typing this on has MSVS 2010 C# Express and Office 2010. I can add a reference to Microsoft.Office.Interop.Excel 11.0.0.0.

'Hope that helps

blocks|key|229580|text|只需添加Microsoft.Office.Interop.Excel引用即可。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|229581|它包含了MicroSoft+Excel相关的类，不需要添加更多的引用。|229582|entityMap^0|4|U|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

Just add reference of <code>Microsoft.Office.Interop.Excel</code>.

It includes MicroSoft Excel related classes, no need to add more references.

blocks|key|228787|text|我猜你正在尝试做的是用using语句添加Microsoft.Office.Interop.Excel，而不是在你的应用程序中添加它的引用，在这种情况下它将不会被找到。在使用using语句调用它之前，您需要添加对您的应用程序的引用。右键单击References并添加Excel+Interop引用。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|228788|entityMap^0|B|5|K|U|2E|5|3B|A|3O|D|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|G|$]]

I guess what you are trying to do is add <code>Microsoft.Office.Interop.Excel</code> with <code>using</code> statement with out adding its reference in your application, in that case it wont be found. Before calling it with <code>using</code> statement you need to add a reference to ur application. Right click on <code>References</code> and add the <code>Excel Interop</code> reference.

blocks|key|228798|text|这里是超级固体解决方案，你只需要在你的调试/发布文件夹中有excell.dll我是77,824字节，我下载了它作为一个文件，这也解释了为什么有些人有调试编译，但发布没有，反之亦然。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228799|特伦托|228800|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Here is super solid solution, you just need have excell.dll in your Debug/Release folder
Mine is 77,824 bytes, I downloaded it as a file, this also explain why some people have Debug compiled but Release not or vice versa.

Trento

blocks|key|228809|text|我自己也有这个问题，接受的答案对我没有帮助，但我用以下方法解决了它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228810|Add+reference+>+Browse+>+C:+>+Windows+>+assembly+>+GAC+>+Microsoft.Office.Interop.Excel+>+12.0.0.0_etc+>+Microsoft.Office.Interop.Excel.dll|offset|length|style|CODE|228811|entityMap^0|0|0|3V|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Just had this problem myself and accepted answer didn't help me but I solved it with:

<code>Add reference &gt; Browse &gt; C: &gt; Windows &gt; assembly &gt; GAC &gt; Microsoft.Office.Interop.Excel &gt; 12.0.0.0_etc &gt; Microsoft.Office.Interop.Excel.dll</code>

blocks|key|229646|text|添加引用>浏览>+C：>窗口>程序集>+GAC+>+Microsoft.Office.Interop.Excel+>+12.0.0.0_wasd..>+Microsoft.Office.Interop.Excel.dll|type|unstyled|depth|inlineStyleRanges|entityRanges|data|229647|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Add reference > Browse > C: > Windows > assembly > GAC > Microsoft.Office.Interop.Excel > 12.0.0.0_wasd.. > Microsoft.Office.Interop.Excel.dll

blocks|key|228842|text|它位于com组件中，命名为："Microsoft+Office+14+Object+Library“|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228843|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

its in the com component, named:
"Microsoft Office 14 Object Library"

blocks|key|2885830|text|答案并不能帮助我解决问题，我无法找到(和浏览)程序集，尽管我使用Microsoft的msi安装程序安装了它们。对我来说，excel程序集位于C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Excel\14.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll下|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2885831|entityMap^0|1Y|3D|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Answers didn't help me to solve my problem, I couldn't find (and browse) the assemblies although I installed them using Microsoft's msi installer. For me, the excel assembly is located under <code>C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Excel\14.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll</code>

blocks|key|3099814|text|我只是遇到了同样的问题，但这些答案对我都没有帮助。我确实在我的pc上的Mostey提到的位置找到了动态链接库：(C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Excel\14.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll)，但这不是我试图构建的项目中引用的那个。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3099815|我们在Visual+Studio2012中的项目中的引用指向C:\Program+Files+(x86)\Microsoft+Visual+Studio+11.0\Visual+Studio+Tools+for+Office\。这个位置对我来说是空的，但对其他人来说工作得很好。我试了很多次，但最终还是找到了一个可以正常工作的安装程序。我希望这能省去其他人同样的麻烦！|3099816|-->++<--|BOLD|3099817|它位于Office+Documentation+and+Download页面上。向下滚动至Tools+Downloads。目前也有一个针对VS2013的。|3099818|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-US/office/aa905340^0|1K|3D|0|U|2B|0|0|3|5|3|0|19|F|3|X|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|10|8|@$9|11|A|12|B|J]|$9|13|A|14|B|J]]|D|@]|E|$]]|$1|K|3|L|5|6|7|15|8|@$9|16|A|17|B|J]]|D|@$9|18|A|19|1|1A]]|E|$]]|$1|M|3|-4|5|6|7|1B|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

I just had the same problem, but none of these answers helped me. I did find the dll on my pc in the location Mostey noted: (<code>C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Excel\14.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll</code>), but this is not the one that was referenced in the project I was trying to get building.

The reference in our project in Visual Studio 2012 was pointing to <code>C:\Program Files (x86)\Microsoft Visual Studio 11.0\Visual Studio Tools for Office\</code>. This location was empty for me, but it worked fine for everyone else. It took a number of tries, but I finally tracked down a working installer. I hope this saves others the same hassle!

--> <a href="http://download.microsoft.com/download/2/F/6/2F6A4FFA-D409-40C8-AF68-F6F0CBE0A00D/ENU/officetools_bundle.exe" rel="nofollow">Office Tools Bundle installer for VS2012</a> &lt;--

This was located on the <a href="http://msdn.microsoft.com/en-US/office/aa905340" rel="nofollow">Office Documentation and Download</a> page. Scroll down to Tools Downloads. There's also currently one for VS2013.

blocks|key|228868|text|我发现它位于VS2013的“汇编”->“扩展”下。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228869|​|228870|📷|atomic|offset|length|228871|228872|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/d4f7a06ed0f5cdb3d83389dbd5363824.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

I found it located under Assemblies->Extensions in VS2013.

<img src="https://i.stack.imgur.com/zqqP7.png" alt="Add Reference">

blocks|key|3099882|text|1.下载和安装:+Microsoft+Office开发人员工具|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3099883|2.从以下位置添加引用：|3099884|C:\Program+Files+(x86)\Microsoft+Visual+Studio11.0\Visual+Studio+Tools+for+Office\PIA\Office15|3099885|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

1.Download and install: Microsoft Office Developer Tools

2.Add references from:

C:\Program Files (x86)\Microsoft Visual Studio 11.0\Visual Studio Tools for Office\PIA\Office15

blocks|key|228883|text|我也遇到了同样的问题，当我将VS2012升级到VS2015时，Microsoft.Office.Interop没有出现在“添加引用”选项中。我基本上修复了安装(控制面板>程序和功能>VS2012>右键单击更改>修复)，并添加了Microsoft+Office组件。在那之后，同样的解决方案开始发挥作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228884|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had the same issue and the Microsoft.Office.Interop was not appearing in "Add Reference" option once I upgraded VS2012 to VS2015. I basically repaired the installation (Control Panel > Programs &amp; Features > VS 2012 > Right click Change > Repair) and added the Microsoft Office component. After that the same solution started working.

blocks|key|3099962|text|自Office2007以来，最好的选择就是使用Open+XML+SDK。我们使用Word.Interop，但它有时会停止，它不建议微软使用它作为服务器端的文档格式化，所以Open+XML+SDK让你可以很容易地在DOCX和Open+XML格式上创建word文档。它让你在可伸缩性、可信度(文件，如果它被损坏可以重建)和另一个非常好的特性方面进展顺利。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3099963|entityMap|0|LINK|mutability|MUTABLE|url|https://www.microsoft.com/en-us/download/details.aspx?id=30425^0|N|C|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

The best option since office 2007 is using <a href="https://www.microsoft.com/en-us/download/details.aspx?id=30425" rel="nofollow">Open XML SDK</a> for it.
We used Word.Interop but it halt sometimes, and it is not recommend for Microsoft, to use it as a server side document formatting, so Open XML SDK lets you creates word documents on DOCX and Open XML formats very easily.
It lets you going well with scability, confidence ( the files, if it is corrupted can be rebuild ), and another very fine characteristics.

blocks|key|228915|text|确保你的项目是32位的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228916|当我在Reference->+assemblies+->Search+"+Office“中勾选”首选32位并重建“所有Office+Interop程序集时，我就遇到了这个问题。|228917|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Make sure your project is 32 bit.

I had this problem, as soon as I ticked "Prefer 32 bit and rebuilt" all the Office Interop assemblies where available in Reference->Assemblies->Search "Office".

I am interested in using C# to manipulate/Automate Excel files.

After browsing the web I have found <a href="http://msdn.microsoft.com/en-us/office/hh133430" rel="noreferrer">VSTO</a> but it seems you can not use that in Visual Studio Express Edition so I can not use that.

Just few minutes ago I noticed a question in this site that used this namespace in its code:

Microsoft.Office.Interop.Excel

So I am wondering if all I need to use that is add necessary reference and if so which reference to add? 

UPDATE

I installed "Primary Interop Assemblies" as the accepted answer suggested but for some reason they are still missing in the Add Reference dialog under ".NET" but they are present in GAC. 

So I just added the reference using "Browse" and located <code>Microsoft.Office.Interop.Excel.dll</code> in GAC folder.

But looking for similar questions on this site regarding adding reference from GAC it seems this is not recommended.

What reference do I need to use Microsoft.Office.Interop.Excel in .NET?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我对使用C#操作/自动化Excel文件很感兴趣。在浏览网页后，我找到了，但似乎你不能在Visual Studio速成版中使用它，所以我不能使用它。就在几分钟前，我注意到这个站点中的一个问题，它在代码中使用了这个名称空间：Microsoft.Office.Interop.Excel所以我想知道我所需要使用的是不是添加必要...

问在.NET中使用Microsoft.Office.Interop.Excel需要什么参考？
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在.NET中使用Microsoft.Office.Interop.Excel需要什么参考？EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在.NET中使用Microsoft.Office.Interop.Excel需要什么参考？
EN