Excel
-
Edit In Excel R2 – Part 2 (out of 2) – the final pieces
It is time to collect the pieces. The full Edit In Excel R2 solution looks like this Slightly more complicated than the first version – but let me try to explain the pieces NAVEditInExcel is the COM object, which we use from within NAV. This actually hasn’t changed a lot, the only small change is, that the EditInExcel method now takes a base URL, a company, a page and a view (compared to just a page and a view earlier)....
-
Dynamic references to NAV Page Web Services in C# – take 2
In this post from April, I explained how to make dynamic references to page based Web Services, but the post really left the developer with a lot of manual work to do using reflection. So – I thought – why not create a couple of helper classes which makes it easier. Basically I have created a generic NAVPageServiceHelper class, which encapsulates all the heavy lifting of reflection and leaves the developer with a set of higher level classes he can...
-
Dynamic references to NAV Page Web Services in C#
Note: There is an updated post about Dynamic references to NAV Page Web Services here. When creating the very first (never published) version of Edit In Excel, it was loosely coupled, meaning that I did not have any Web references in the project to the Customer Page, Vendor Page or other pages. I read the WSDL and used XPath to traverse the XML and build up structures and I was able to attach to any Page Web Service. The code...
-
Edit In Excel R2 – Part 1 (out of 2)
This post assumes that you have read the 4 step walkthrough of how to build the Edit In Excel demo from November 2008. You can find the parts here: Part 1, Part 2, Part 3, Part 4 and the Bug Fix. In this post I will talk about what is needed in order to be able to save an Excel spreadsheet on a local disc, edit it offline and then submit your changes later. My first assumption was that this...
-
Edit In Excel – bug fix and R2
If you haven’t read the 4 step walkthrough of how to Edit In Excel from Microsoft Dynamics NAV, you should do so here this post is a follow up to the original posts. I have received a number of suggestions to what you could do with the Edit In Excel and a single bug. In this post I will fix the bug and I will explain what R2 is all about. The Bug The bug description is, that if you...
-
Edit In Excel – Part 4 (out of 4)
If you haven’t read part 3, part 2 (and part 1), you should do so before continuing here. We have seen how to put code inside Excel, using VSTO and connect to NAV 2009 Web Services. We have seen how to add this to a table inside Excel and how to write data back to NAV through Web Services. We can delete, add and modify records in Excel and we can even do so with both Customers, Vendors and Items....
-
Edit In Excel – Part 3 (out of 4)
If you haven’t read part 2 (and part 1), you should do so before continuing here. In Part 1 and 2, we have seen how easy it is to add a Web Service Reference inside Excel, and use it to get Data. In Part 2 we even had the ability to modify data and send this back to NAV. The original intend was that part 3 would be all about integrating this to NAV on the Client side and part...
-
Edit In Excel – Part 2 (out of 4)
If you haven’t read Part 1, you should do so before continuing here. In Part 1 we saw how easy it is to white .net code inside Excel, and get it executed based on an event in Excel, and how easy it is to fill values into cells. But in order to make this really useful we need to go a different way around. First of all, we need to know more about the record we are working with. We...
-
Edit In Excel – Part 1 (out of 4)
For the last 6-9 months, Microsoft have been showing a demo of how a user could create a filter on a list place and invoke an action called Edit In Excel. This would open Microsoft Excel with the same records, the user selected in the List Place and allow the user to edit values and post modifications back to Microsoft Dynamics NAV, showing how the user would get a runtime error if he was trying to violate validation logic from...
