My struggles in understanding and learning about Object Oriented design, and the tools and knowledge I've taken from them.

Friday, June 28, 2013

A defect in the updated NPOI Wrapper

I've discovered a defect in the new NPOI wrapper I built, where creating a XLSX file results in Excel saying there was "unreadable content," and that some data corruption occurred. I think I've fixed the code, but will need several more days to do some exhaustive testing. The exact same code with XLS format does not result in the error - it's only using the XSSFWorkbook that this error occurs, which leads me to believe that the NPOI 2 beta is not as stable as I thought...although, it still is a great tool, despite this.

Thursday, June 20, 2013

NPOI Now Supports Excel 2007 and Later

NPOI's latest release, which as of 6/20/2013 is still in beta, now supports XLSX files. This is really great news, because as the world's technology problems get bigger, it needs spreadsheets that support more than 65,000 rows and 256 columns.

I'm a little bit late to the party -- the beta was released in March -- but I've been too busy lately to get to reviewing it.

I've modified my wrapper to support the new XSSFWorkbook class, so the usage of my wrapper remains essentially the same - see http://oopstruggles.blogspot.com/2011/12/npoi-wrapper.html for usage.

*** Download the wrapper here. ***

The newest NPOI download can be found at http://npoi.codeplex.com/releases/view/97124

One of the things that I'd like to add in my wrapper is support for Excel ranges. It doesn't support that yet, and that will definitely be the next thing I add...hopefully in the next month or two.

Followers

Search This Blog

Powered by Blogger.