JExcelAPI is a neat “Java API to read, write, and modify Excel spreadsheets”, written by Andy Khan. It is very easy to use and it does a great job. Unfortunately, at work I have to deal with .NET projects as well. I thought it would be great to take advantage of the JExcelAPI’s functionality in my .NET projects too, and get rid of the Microsoft Interop crap.
Thankfully, porting JExcelAPI to .NET was a piece of cake because all source files could be easily imported into a J# class library project, and compile with nothing but slight changes. To use it, download the visual studio solution and build the class library (you will need vs 2005). If you are not familiar to JExcelAPI, you can take a glance at the Test C# project do get an idea of how it works. However, make sure that you read the tutorial. Javadoc is also available.
I want to clarify that I did nothing more than drag’n'drop the original java files into a J# project. All glory and honour goes to Andy Khan. Thank you Andy.
- NExcelAPI-2.6.4.zip (795KiB)