Q:

Is there an alternative library to Microsoft.Office.Interop.Excel?

I am using the Microsoft.Office.Interop.Excel reference in order to have some manipulations with excel files, like adding columns, locking cells, protecting with password etc...
Now I have to use this code on a server that doesn't have office installed on it, so I don't really know for sure if the code using this reference will be able to run there.
So is there a way of doing all these actions on excel files on a server that doesn't have office installed on it ?
Should I use another library or is there a way that the Microsoft.Office.Interop.Excel reference to work with no office installed ?

A:

You can use EPPlus. It works with Open Office Xml format. No need to install any Office component on the server.
http://epplus.codeplex.com/

A:

ClosedXML is another open source library for manipulating Excel files (with an API similar to the COM object model).

