是否有其他图书馆的Microsoft.Office.Interop.Excel？ [英] Is there an alternative library to Microsoft.Office.Interop.Excel?

问题描述

我为了现在用的的Microsoft.Office.Interop.Excel 引用有一定的操作与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...

现在我已经不上安装了办公室服务器上使用此代码，所以我如果代码使用真的不知道肯定该参考文献将能那里运行。
那么，有没有这样做，不具有在其上安装Office的服务器上的Excel文件所有这些行动的一种方式？
我应该使用其他库或者是有办法的的Microsoft.Office.Interop.Excel 参考，没有安装Office？

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 ?

推荐答案

ClosedXML 是另一个开源库操纵Excel文件（有类似COM对象模型的API）。

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

这篇关于是否有其他图书馆的Microsoft.Office.Interop.Excel？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！