Lots of customers have subroutines that have been developed to provide specific functionality.  With the FusionWare mvLynx Direct Data Access Server you can quickly and easily make these subroutines accessible.  Once exposed, these can be called from .NET, Java, PHP and many more environments.

We will start by giving you an example subroutine and calling it from a test harness from TCL.  Then we will show how we expose it for consumption.  Next we'll actually call it, in this case, from a .NET console application.  Finally, we'll talk about some gotchas and ways to work around them.

We take the automapped ORDERS file from the Demo account on Unidata for Windows and pull the single values, multi values and sub values into three different spreadsheets, named Orders, OrderLines and Options.

This post was modified May 4th, 2011 to reflect initial steps to take for customers who don't have Microsoft Office Tools for Visual Studio.  It now works for just Microsoft Excel 2007 or 2010.