Thought i might link this here as some people are finding this handy. There is a C# port of this too.
This NPOI wrapper/helper aims to make reading and writing of Excel files extremely easy (only a few lines to read or write an entire sheet), then exposes the NPOI object so you may do other more advanced operations. NPOI has various examples included, but
they are basic and the API is complex for many people's usage. My VB.NET 2.0 code (or the C# port) makes it very easy to read an entire worksheet or update or write new sheets with some formatting. I have also included a sub to export a Data Table to an XLS
file in 2 lines of code. This class is not meant to be the be all and end all of Excel reading and writing. It is just meant to give you a "leg up" so you can to do the basics or get started with NPOI. This class, with a few unreleased extras specific
to my apps covers 99% of my corporate usage - so i hope it helps other people out too.
See the second download here: