This project is read-only.

NPOI VB.NET wrapper to help read/write in only a few lines

Aug 26, 2010 at 3:06 AM

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: http://www.beanland.net.au/programming/dotnet/