Introduction and Comparison of. Net Excel Free Open Source Class Libraries

From http://yuxnet.blog.163.com/blog/static/

Since the last time I found npoi, I found some open-source free class libraries based on the clues provided by yuanyou and Google, so I had a simple experience.

Find the following class libraries:

1. Myxls (http://sourceforge.net/projects/myxls)
2. Http://sourceforge.net/projects/koogra/ (koogra)
3. Excellibrary (http://code.google.com/p/excellibrary)
4. Excelpackage (http://excelpackage.codeplex.com /)
5. Epplus (http://epplus.codeplex.com /)
6. Linqtoexcel (http://code.google.com/p/linqtoexcel)
7. Netoffice (http://netoffice.codeplex.com/) requires installation of Office EXCEL

From class libraries 1 to 6, you do not need to install the office or the office COM component. While netoffice needs to install the Office, which provides functions similar to the office COM component.

Myxls

Myxls supports Office EXCEL 97-2003 format (biff8 format). HoweverFormula is not supported.That is, the formula;It is a false saying that 2007 is supported on the Internet..

Note that it is the same as office Pia,The index number starts from 1..

What I have to say is that its constructors, save methods, and filename in the attributes are confusing and confusing -_-.

Koogra

Koogra supports Office 97-2003 (biff8) and Office 2007 or later (XLSX) formats, but it only provides the READ function and does not have relevant Excel creation functions.The index number starts from 0 again..

My tests on several machines are not very stable, that is, some machines cannot run directly, so I did not go into any further problems.

Excellibrary

I heard that this is developed by Chinese people. Currently, the 97-2003 (biff8) format is supported, and the XLSX format may be supported in the future. It uses a two-dimensional array, which is close to office Pia. In addition, itsThe index number starts from 0..

During the test, the Excel files created are sometimes empty and may contain bugs.

It provides a datasethelper tool class for conversion between able/dataset and workbook, but this tool class does not support streaming operations.

Excelpackage and epplus

Excelpackage mainly supports ooxml, which is the office open XML standard. It supports reading and writing in XLSX format above Office 2007. However, it does not support streaming operations and only supports operations on object files.

EpplusThe full name should be excelpackage Plus, which is the enhanced version of excelpackage. Based on excelpackage, it enhances many functions including streaming and LINQ support, which can be said to be quite good.

ItsThe index number starts from 1..

Linqtoexcel, netoffice...

As for linqtoexcel, it can only be said to be a sugar, and it does not support streaming operations. It is really no love, not to mention.

Netoffice provides features similar to office Pia and requires Office installation. It is not suitable for use in Web scenarios.

 

End

For Excel 97-2003 format, it is best to use npoi, And the API design is relatively good (the above class libraries are 0 and 1 index numbers and two-dimensional arrays are really confusing); for 2007 (XLSX) for the above versions, you can use epplus. In this way, all the EXCEL formats are available.

Of course, this is only a free solution. For those without oceans, it is another thing to use powerful commercial solutions such as apose. Cell.