How to Read Excel Files in VB.Net with NPOI – no Office or OLEDB or ODBC required!
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!

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

https://www.patreon.com/mackenziedataengineering

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
https://www.facebook.com/mackenziedataanalytics
https://twitter.com/seamacke
https://www.instagram.com/seamacke/
https://www.reddit.com/user/seamacke
https://www.linkedin.com/in/psmackenzie/

For developers looking for a new role, check out:
https://www.toptal.com/qKaO2b/worlds-top-talent

Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-top-talent

#NPOI #ExcelVb.net

https://youtu.be/u6NU7Stpe6s