Solved

Microsoft Excel Interop

Posted on 2014-02-21
3
396 Views
Last Modified: 2014-02-24
I have tried to set up an application on a server that is using microsoft excel interop.  When trying to do the installation I get errors relating to entry points.  I installed Office on the server to test whether it is related to libraries.  The installation worked but I cannot leave office on the server.  

Does anyone know what libraries or other factors I need to include or be aware of when installing excel interop as part of a VB installation
0
Comment
Question by:Alyanto
3 Comments
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 400 total points
Comment Utility
To use interop, you need to install the software. You cannot just copy some DLLs.

What are you trying to do? Read Excel file? Create some?

To read simple files, check http://emoreau.com/Entries/Articles/2013/07/A-free-LINQ-to-Excel-and-CSV-provider.aspx

If you need to create files, check http://emoreau.com/Entries/Blogs/2009/01/Another-way-to-manipulate-Excel-files.aspx
0
 
LVL 35

Assisted Solution

by:Miguel Oz
Miguel Oz earned 100 total points
Comment Utility
I f you can not leave Office installed in the server then you can not use Excel Interop.
Excel interop (the one coming in  .NET 4.0) relies on the correct Office version to be installed in your server, For example the interop libray 14.0.0 requires Excel 2010  as shown in the link below:
http://msdn.microsoft.com/en-us/library/ee342218.aspx

If you are planning to have application that does not to use Office then you must change your application to use third party components that do not need Office, for example:
Commercial: (No need to install excel on server)
http://www.gemboxsoftware.com/GBSpreadsheet.htm
Opne source:
https://npoi.codeplex.com/
0
 

Author Closing Comment

by:Alyanto
Comment Utility
Thank you both your answers lead to a complete solution for me.  

@Eric.  With your blog this link is broken

http://nayyeri.net/blog/use-excelpackage-to-manipulate-open-xml-excel-files/.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video discusses moving either the default database or any database to a new volume.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now