Spreadsheet Link per Microsoft Excel

Key Features

  • Data preprocessing, editing, and viewing in the familiar Excel® environment
  • Sophisticated analysis of Excel data using MATLAB® and application toolboxes
  • Delivery of Excel based applications, using MATLAB as a computational and graphics engine and Excel as an interface
  • Interactive selection of available functions using the MATLAB Function Wizard
  • Visual interface for customization of all Spreadsheet Link preferences

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.

The MATLAB® Function Wizard for Spreadsheet Link™. You can browse MATLAB® directories and functions from Excel® and run selected functions from an Excel spreadsheet.

Working with Spreadsheet Link™

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:

  • Manage the link between the two software environments
  • Start MATLAB automatically when you start Excel
  • Transfer data between MATLAB and Excel in both directions
  • Execute any MATLAB function directly from Excel
  • Use the MATLAB Function Wizard to visually navigate the complete list of MATLAB functions, specify input data and run a selected function

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.

The Preferences dialog, which you can use to configure your environment.