A while ago I created my own, simple Excel .xlsx creation library for .net 4.0+. The reason I did this was because I was unhappy with the ones on the market – many of them tried to replicate every feature Excel has to offer but don’t test actually against the actual Excel application and thus miss things like sheet lengths/invalid characters (which are NOT part of the OpenXML Spreadsheet standard) or allow to otherwise create invalid Excel files, prompting Excel to give you a super useless “Invalid data found, do you want to recover?”.
Simplexcel is my attempt at a library that may not offer all the features Excel can do, but tries to make sure that every feature actually works with every applicable version of Excel (2007, 2008 for Mac, 2010, 2011 for Mac and 2013).
Today I updated it:
Version 1.0.3 (2013-08-20)
- Added support for external hyperlinks
- Made Workbooks serializable using the .net DataContractSerializer