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

preview_player
Показать описание
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 :

Demo of my BZ RDP Cloaker:

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

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

For developers looking for a new role, check out:

Want my team to do a project for you? Let's get to it!

Рекомендации по теме
Комментарии
Автор

I wish all videos were like this. Just simple step by step, how to do something. No building a whole program and leaving to the watcher to figure out how to implement it. Great job!

printchecks
Автор

Does this library allow you to check in and check out files?

leviapplebaum
Автор

Very nice tutorial. Thanks ..I am facing one issue...When I am converting my xlsx to html using exceltohtmlconverter.processworkbook(), I am getting "Illegal IndexedColor index: 0" exception. Could you please help me on this issue.

shashankjan