Spreadsheet Link is especially useful as an array editor for viewing and editing data in any MATLAB application. Any data that you can import into Excel can be passed to MATLAB for analysis and visualization. The connection between MATLAB and Excel is "live" and requires no intermediate files or low-level, inter-process programming.
Spreadsheet Link features an Excel spreadsheet add-in that provides the functions that connect Excel and MATLAB. The add-in handles interprocess communications between Excel and MATLAB through ActiveX®.
Excel provides a familiar interface that lets you edit and view your data. Spreadsheet Link lets you pass data, and commands that operate on it, to MATLAB. Spreadsheet Link functions let you:
With Spreadsheet Link, Microsoft Excel becomes an easy-to-use data-storage and application-development front end for MATLAB. You work with Spreadsheet Link functions from an Excel worksheet or macro without leaving the Excel environment. You can use the Excel interface to edit and view your data and then use Spreadsheet Link to pass data and commands to MATLAB. You can pass data stored in an Excel spreadsheet to the MATLAB workspace. Similarly, you can easily bring data from the MATLAB workspace into an Excel spreadsheet.
The MATLAB workspace includes all the variables created by MATLAB, Handle Graphics®, and related toolboxes. MATLAB functions can access and share the data in these variables, and you can call these same MATLAB functions from Excel formulas, macros, or Excel Visual Basic® subroutines or functions.
Because both MATLAB and Excel are extensible, you can develop and incorporate your own data analysis functions and techniques.