You can now export data in Microsoft® Excel® named ranges to MATLAB® using the MLPutRanges function in the command line or Microsoft Excel ribbon.
This function wizard enables you to browse MATLAB directories and run functions from within the Microsoft Excel interface. You can use it to:
Display a list of all MATLAB function categories or directories.
Choose a particular directory or category, and list functions available for that directory or category.
Display online help headers for functions.
For more information, see Using the MATLAB Function Wizard for Excel Link Software in the Excel Link documentation.
You can set selected MATLAB preferences from within the Excel Link GUI by using the Preferences dialog box. This new feature enables you to:
Automatically start a MATLAB session when a Microsoft Excel session starts.
Specify the current working directory for your MATLAB session at startup.
Start the MATLAB desktop, including the current directory, workspace, command history and command window panes, when a Microsoft Excel session starts.
Enable the MLPutMatrix function to use cell arrays for transfer of data between a Microsoft Excel worksheet and the MATLAB workspace.
Set data in missing or empty cells to NaN or zero.
For more information on Excel Link Preferences, see Setting Excel Link Preferences in the Excel Link documentation.
This releases supports the following new functions:
MLGetFigure imports a MATLAB figure into a Microsoft Excel spreadsheet.
MLStartDir specifies the current working directory for a MATLAB session after startup.
MLUseFullDesktop specifies whether to use the full MATLAB desktop or only the Command Window.
MLShowMatlabErrors uses MLEvalString to return standard Spreadsheet Link EX errors or full MATLAB errors.
Version 2.3 of the Excel Link software uses the MATLAB software as a COM automation server with the full desktop displayed.
Excel Link software requires approximately 202 kilobytes of disk space. Operating system requirements are:
Microsoft Windows® XP
Microsoft Windows 2000
Excel Link software requires one of the following versions of Microsoft Excel software:
Excel 98 software
Excel 2000 software
Excel 2002 software
Excel 2003 software
Excel Link software also requires Version 5.1 or later of the MATLAB for Windows software.