Basic pre-requisites to use NetOffice

Nov 29, 2013 at 5:48 AM
Edited Nov 29, 2013 at 5:49 AM

I am using NetOffice for the first time.

I am making an ASP.NET web site where on click of a button, I want to generate an Excel file in a password protected state and send it to the client to download it.

But I want to know whether, will I require MS Excel installed on the server?
OR Is there a way where I can make this work on a server where MS Excel is NOT installed?

Also what are other pre-requisites?
Nov 29, 2013 at 10:52 AM
Yes, you will need to have Excel installed. NetOffice is just a COM wrapper for Office. Without Office it won't work.
Dec 10, 2013 at 11:39 AM
ClosedXML allows you to create Excel 2007/2010 files without the Excel application. The typical example is creating Excel reports on a web server.
Dec 11, 2013 at 8:15 PM
i agreed this. you may need to take a look to the ClosedXML project
NO is a helper to create desktop addins. the ClosedXML project allows yout to create excel very very easy without excel because this means to manipulate some xml files(xlsx). a side effect: you need XL 2007 or higher.