Excel Interoperability Woes in NAV 2013

  • Post comments:30 Comments

Handling Excel files in NAV 2013 (including R2) is not as easy as it seems at first. The Excel Buffer table – an obvious choice of the old days – supports only Open XML format (*.xlsx), and Excel Interoperability implementation seems a bit buggy (check the comments in my old post about .NET interoperability: https://vjeko.com/blog/the-beauty-and-the-beast-nav-and-net). You can still use automation, but then you must handle everything, or at least most of it, on the client end. And, to make it all just a bit worse, none of these approaches, even when they work, will impress you with their speed. All in all, if you want to handle legacy Excel files (*.xls) you will have to make some compromises.

Last week, Mark asked me for a bit of help on a project where he had to import *.xls files into NAV 2013, and he hit all of the possible walls provided by the Excel Buffer, .NET Interoperability components for Excel, and automation walls possible.

When I gave Mark my solution, he said: you should blog about this. So, here I am, blogging about a simple way to read data from Excel, any version, lightning fast.

(more…)

Continue Reading Excel Interoperability Woes in NAV 2013

Two more Microsoft Dynamics NAV books

  • Post comments:0 Comments

As reported by Marq, two more Microsoft Dynamics NAV books have been published by PACKT this week: Microsoft Dynamics NAV 2009 SP1 Programming Cookbook by Matt Traxinger and Microsoft Dynamics…

Continue Reading Two more Microsoft Dynamics NAV books

Development Best Practices

  • Post comments:0 Comments

“Best practices” is one of those beloved and hated concepts. There are people who just embrace “best” practices for the sake of their bestness. And there are people who just…

Continue Reading Development Best Practices

A new book about Microsoft Dynamics NAV

  • Post comments:3 Comments

Back in my time (now I feel old :)) if you wanted to read a book about Microsoft Dynamics NAV, you just couldn’t—there wasn’t any available. Today, if you want to learn about NAV, not only there are books about programming and implementing, but with new Mark Brummel’s book you can now learn about the most important aspect of Microsoft Dynamics NAV customization projects—the application design. The book hasn’t yet been published, but is already available for preorder through PACKT Publishing at the following link: Microsoft Dynamics NAV 2009 Application Design.

(more…)

Continue Reading A new book about Microsoft Dynamics NAV