Is Office required to have installed on the machine with Interop dll?
-
Hello Experts, I am generating a function that Exports to Excel using Interop.dll in Vb.net. So Do you think that I need to install office for this on Server machine if I deploy the application? Are there any other things that does export to excel and which will not require Office to be installed on the server machine?
Your help is much appreciated. Thanks Happy Coding!
-
Hello Experts, I am generating a function that Exports to Excel using Interop.dll in Vb.net. So Do you think that I need to install office for this on Server machine if I deploy the application? Are there any other things that does export to excel and which will not require Office to be installed on the server machine?
Your help is much appreciated. Thanks Happy Coding!
"Interop" dlls are just .net wrappers around COM objects that allow your .net code to use the underlying COM objects. For the code to function after being deployed, the COM object the interop is a wrapper for needs to exist, so in your case those objects are provided by Excel, so Excel needs to be installed on the server. Legal and license issues aside, you're not going to get this working reliable (if at all) and it isn't supported by Microsoft. Look to another way of generating excel files like Open XML, Adpose, the excel odbc driver, DocX etc.
-
Hello Experts, I am generating a function that Exports to Excel using Interop.dll in Vb.net. So Do you think that I need to install office for this on Server machine if I deploy the application? Are there any other things that does export to excel and which will not require Office to be installed on the server machine?
Your help is much appreciated. Thanks Happy Coding!
Considerations for server-side Automation of Office[^]:
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
There are various ways to create Excel spreadsheets on the server without using Office interop. For example:
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Hello Experts, I am generating a function that Exports to Excel using Interop.dll in Vb.net. So Do you think that I need to install office for this on Server machine if I deploy the application? Are there any other things that does export to excel and which will not require Office to be installed on the server machine?
Your help is much appreciated. Thanks Happy Coding!
Yes, so don't use interop.
-
Considerations for server-side Automation of Office[^]:
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
There are various ways to create Excel spreadsheets on the server without using Office interop. For example:
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Yes, so don't use interop.
-
Hello Experts, I am generating a function that Exports to Excel using Interop.dll in Vb.net. So Do you think that I need to install office for this on Server machine if I deploy the application? Are there any other things that does export to excel and which will not require Office to be installed on the server machine?
Your help is much appreciated. Thanks Happy Coding!
-
Hello Experts, I am generating a function that Exports to Excel using Interop.dll in Vb.net. So Do you think that I need to install office for this on Server machine if I deploy the application? Are there any other things that does export to excel and which will not require Office to be installed on the server machine?
Your help is much appreciated. Thanks Happy Coding!
Hi, You Can use Open XMl SDK 2.0 or higher for the Export/Import excel functionality. Plase have a look at my below article. http://www.codeproject.com/Articles/884166/Excel-worksheets-by-using-the-Open-XML-SDK[^] If you want i can upload e example too.
