How to Read Excel Files using VB.Net with NPOI - no Office or OLEDB or ODBC required

23-July-2021
Working with Excel files in code has often been a challenge, especially when your target computer does not have the right OLEDB or ODBC drivers, or a MS Office installation for interop. In this case, we can use a package from NuGet called NPOI, which will install into your project and be ready to tackle your Excel files and data transformations. With NPOI you can open, read, and modify Excel sheets without having any additional resources handy. This one is a great addition to your data engineering toolkit!



Data Engineering Project? Contact me today!