MATLAB: How to echo MATLAB commands from Spreadsheet Link EX in the MATLAB command window

commanddisplayechoexcellineoutputSpreadsheet Linkvba

I am calling MATLAB functions from Excel using Spreadsheetlink EX. I included DISP commands or finished expressions with ',' rather than ';' in order to display intermediate results. However the MATLAB command window does not show any outputs when calling MATLAB from Excel.

Best Answer

The ability to have Spreadsheet Link EX macros echo its commands in MATLAB's command window is not available in Spreadsheet Link EX 3.0.3 (R2009a).

Please consider the following workaround.

1. Use message box to display the result

you can add a code using MsgBox to the VBA program as follows.

MsgBox ("The output is" & Result)

Also , there is an example of displaying an error message in a message box in the following documentation.

· Display MATLAB Errors in VBA Macro

https://www.mathworks.com/help/exlink/mlshowmatlaberrors.html#bvbyuh4-6

For the details of MsgBox, please refer to the external site.

2. Save the result as a file

In a MATLAB program, you can add functions to save to a file such as fopen / fprintf / fclose, and save the result as a file.

Related Solutions

MATLAB: What are the limitations of XLSREAD when run in ‘basic’ mode

On Windows systems with Microsoft Excel software, "xlsread" reads any file format recognized by your version of Excel.

If your system does not have Excel for Windows, "xlsread" operates in "basic" import mode.

Flag to request reading in 'basic' mode, specified as the literal string, 'basic'

'basic' mode is the default for systems without Excel for Windows. In 'basic' mode, "xlsread"

Reads XLS, XLSX, XLSM, XLTX, and XLTM files only.
Does not support an 'xlRange' input when reading XLS files. In this case, use '' in place of 'xlRange'.
Does not support function handle inputs.
Imports all dates as Excel serial date numbers. Excel serial date numbers use a different reference date than MATLAB date numbers

The appropriate syntax for using "xlsread" in 'basic' mode may be found in the following documentation page:

<http://www.mathworks.com/help/matlab/ref/xlsread.html>

You may access the same page locally by typing the following at the MATLAB prompt:

web(fullfile(docroot, 'matlab/ref/xlsread.html'))

MATLAB: Do I receive a “Run-time error ’13’: Type mismatch” error when I try to access the data returned by MLGETVAR

This change has been incorporated into the documentation in Release 2009a (R2009a). For previous releases, read below for any additional information:

The type mismatch error is due to the type of the variable (DataJ) that is used to hold the value returned by MLGETVAR command. The variable that is created by MATLAB to hold the value when MLGETVAR returns is of type Variant() - that is, it is an array of Variants.

Since the returned variable DataJ is an array, it must be indexed in order to use the values it contains. Thus, the call to MsgBox should be coded as follows if the variable J in the MATLAB workspace is a scalar:

MsgBox(DataJ(1,1))

This will cause the VBA code to run without error.

Likewise, if J is a matrix of dimension MxN in the MATLAB workspace, you can index into the corresponding (m,n)-th element in DataJ with the following statement:

MsgBox(DataJ(m,n))

All other VBA array conventions apply.

A similar example of indexing into a Variant() variable as returned by MLGETVAR can be found in the following Spreadsheet Link EX example in the documentation:

https://www.mathworks.com/help/releases/R2019b/exlink/index.html

If you have installed the help documentation, you may access the same page locally by typing the following at the MATLAB prompt:

web([docroot,'/toolbox/exlink/f2-2311.html#brfcgkq'])

Best Answer

Related Solutions

MATLAB: What are the limitations of XLSREAD when run in ‘basic’ mode

MATLAB: Do I receive a “Run-time error ’13’: Type mismatch” error when I try to access the data returned by MLGETVAR

Related Question