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 Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link 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/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering 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://www.youtube.com/watch?v=u6NU7Stpe6s