Excel Link for O-Matrix

The The Excel Link for O-Matrix integrates the high-performance technical computing capabilities of O-Matrix with the convenient and well-known Microsoft Excel environment. Excel Link lets you exchange data between O-Matrix and Excel worksheets or VBA, (Visual Basic for Applications) macros.

• Transfer data and commands to and from O-Matrix using familiar Excel worksheet functions
• Enter, edit, and view data in the familiar point-and-click Excel environment
• Create end-user solutions using the Excel interface
• Combine the best language capabilities of O-Matrix and VBA
• Build VBA applications and GUIs that use O-Matrix as a numerics server

Use the Excel Link to perform numerical analysis in Excel. This example uses O-Matrix to calculate a wavelet transform of data from Excel.



Using the Excel Link makes all of Excel' data I/O, display, and calculation capabilities available to O-Matrix. This example illustrates loading SQL data into O-Matrix using the Excel Link.



    "O-Matrix lets me solve a class of problems not possible in Excel"
    - Dr. Stuart Knoke, Northwest Research Associates

System Requirements

• O-Matrix 5.8 or greater
• Windows NT, 2000, or XP
• Excel 2000 or Excel XP
• 1 MB Available Disk Space