CODEWITHSUNDEEP
c#excel
Liran Friedman
Liran Friedman

Reputation: 4287

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 ?

Upvotes: 7

Views: 13228

Answers (4)

Baran
Baran

Reputation: 1408

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

Upvotes: 6

Govert
Govert

Reputation: 16907

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

Upvotes: 6

alex.pulver
alex.pulver

Reputation: 2125

EasyXLS is also a library for Excel file manipulation that covers all the requests that you mentioned.

Upvotes: 1

Vijay Gill
Vijay Gill

Reputation: 1518

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

Upvotes: 1

Related Questions