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

Question

I use the link Microsoft.Office.Interop.Excelto have some manipulations with excel files like adding columns, blocking cells, password protection, etc.

Now I have to use this code on a server on which the office is not installed, so I do not know for sure whether the code using this link can work there. So, is there a way to do all these actions on excel files on a server on which the office is not installed? Should I use another library or is there a way that the link Microsoft.Office.Interop.Excelworks without an office?

Answer 1

ClosedXML - Excel ( API, COM).

Answer 2

EPPlus. Open Office Xml. - Office . http://epplus.codeplex.com/

Answer 3

Another open source option is spreadsheetlight . I have been using it for quite some time.

Answer 4

EasyXLS is also an Excel file processing library that covers all the queries you specify.