I am interested in using C# to manipulate/Automate Excel files.
After browsing the web I have actually found VSTO however it seems you can not use that in Visual Studio Express Edition so I can not utilize that.
Just couple of minutes ago I discovered a concern in this site that utilized this namespace in its code:
Microsoft.Office.Interop.Excel, if you don’t want to add the reference to this COM, you can use an alternative library http://www.iditect.com/product/excel/ to edit Excel using C# in .NET application.
So I am wondering if all I have to utilize that is include required referral and if so which referral to include?
I installed “Main Interop Assemblies” as the accepted answer recommended but for some reason they are still missing out on in the Add Recommendation dialog under “. NET” but they exist in GAC.
So I simply added the recommendation utilizing “Browse” and located Microsoft.Office.Interop.Excel.dll in GAC folder.
Looking for comparable concerns on this website regarding adding referral from GAC it seems this is not advised.
These are readily available as “Main Interop Assemblies”, which can be set up with Workplace, or downloaded and set up independently. How to: Set Up Workplace Main Interop Assemblies.
I only had the precise very same complication, nonetheless none of these responses assisted me. I performed locate the dll on my personal computer in the region Mostey kept in mind: (C: \ Microsoft window \ installation \ GAC_MSIL \ Microsoft.Office.Interop.Excel \ 126.96.36.199 \ Microsoft.Office.Interop.Excel.dll), but this is actually neither that was actually referenced in the venture I was actually intending to get design.
The greatest alternative considering that work environment 2007 is making use of Open XML SDK for it. Our company took advantage of Word.Interop however it stop in some situations, as well as it is certainly not recommend for Microsoft, to utilize it as a web server edge documents layout, therefore Open up XML SDK permits you establishes word files on DOCX and Open XML styles extremely simply.
The referral in our venture in Visual Studio 2012 was suggesting C: \ Plan Documents (x86)\ Microsoft Visual Studio 11.0 \ Visual Workshop Tools for Office \. This place was unfilled for me, nevertheless it worked great for everyone else. It took a variety of gos, nevertheless I finally positioned an operating installer.
Those are COM companies that Visual Workshop may generate.NET interop installations for. It is actually certainly not recommended that you make use of those; you ought to use the PIA settings up launched coming from Microsoft. They should reveal up in the.NET button in the Include References discussion.
For example, the COMPUTER I am actually typing this on possesses MSVS 2010 C# Express and Work Environment 2010. I can easily add a referral to Microsoft.Office.Interop.Excel 188.8.131.52.
You ought to manage to add a suggestion to Interop.Excel if you have actually Microsoft Place of work put up.
As quickly as those are actually specified up, you can reference them in your task in the Include Suggestion dialog, under.NET. If you perform certainly not view those Microsoft.Office.Interop assemblies specified, at that point they have not been actually established up. Mount them coming from your settings, or download as well as mount them individually (find my web link over for the downloads).
I think exactly what you are actually targeting to do is actually add Microsoft.Office.Interop.Excel with utilizing claim along with out including its own reference in your application, due to the fact that case it wont be actually found out. Before phoning it with using declaration you need to have to consist of a reference to ur application. Click on Recommendations as well as incorporate the Excel Interop referral.