Last post Mar 29, 2011 09:04 AM by CikaPero
Dec 09, 2010 12:14 PM|robinspaul|LINK
My server administrator does not allow me to install Microsoft Office in the server.
I have developed a website which converts XML files to Excel and it is using
Is there any way I can run this application without installing Microsoft Office in the server?
Dec 09, 2010 12:32 PM|prasadP|LINK
Unfortunately you need to have Microsoft Excel installed in order to have access to the Introp libraries that you need to add as references to your project in order to make it work.
Try using some other alternative
NPOI - Which is free and open source.
Aspose - Is definitely not free but robust.
Spreadsheet ML - Basically XML for creating spreadsheets.
Dec 09, 2010 12:45 PM|sachingusain|LINK
There is no way you can do it without installing it.
If you are forced to and have an option to look at 3rd party vendors then you can evaluate
I am using it and its pretty easy to start with with little learning curve and it removes the dependency on Microsoft's interop.
Dec 09, 2010 04:06 PM|robinspaul|LINK
Do I need to install the entire Microsoft Office? If it is just a few assemblies or libraries my administrator will allow it.
Can I make a dll of Microsoft.Office.Interop.Excel and put it in my bin folder?
Dec 09, 2010 04:55 PM|sachingusain|LINK
If you need to use just Excel then install excel only.
Dec 09, 2010 08:44 PM|sirdneo|LINK
You need to install MS Excel on your server to ensure that Interop.Excel works fine. One alternate can be that you use OpenXML format to generate excel reports, for details see:-
Dec 09, 2010 09:10 PM|teddy_q|LINK
You can also use the fake excel method. See this post
Mar 29, 2011 09:04 AM|CikaPero|LINK
Excel Interop is not recommended in server environments, even by Microsoft.
If you are looking for reliable and fast
Excel C# / VB.NET library, I recommend GemBox.Spreadsheet.