MATLAB: How to debug the MATLAB code called from Excel using Spreadsheet Link

debugexexcellinkspreadsheetSpreadsheet Link

I have written a function in MATLAB which I am calling from Excel using Spreadsheet Link. I want to be able to debug my MATLAB code when I run the VBA code.

Best Answer

Before you begin, I recommend closing all open MATLAB sessions. Spreadsheet Link will start an instance of MATLAB to use. Closing other MATLAB windows will make it easier for you to locate the MATLAB instance started by Excel.

Open Excel
Verify that you have the correct preferences set to be able to debug:
Select "Preferences" from the MATLAB menu in the "Home" tab of the ribbon.
Check "Use MATLAB desktop".
Click "OK"
Start MATLAB from Excel
Select "Start MATLAB" from the MATLAB menu in the "Home" tab of the ribbon.
You should see MATLAB start.
In MATLAB, navigate to the folder where the function you want to debug is present.
Put a break point in that function.
In Excel, run the VBA code which calls the MATLAB function.

Related Solutions

MATLAB: How to use Excellink functions in a Excel Macro Function instead of a Sub

The above Macro Subroutine can be translated to the following Macro Function:

Function Calculate(A As Range, b As Range) As Variant
    MLOpen
    MLPutMatrix "A", A
    MLPutMatrix "b", b
    MLEvalString "x = myfunc(A, b)"
    MLGetVar "x", Calculate
End Function

The inputs to MLPutMatrix are Ranges. MLGetVar is used to write the "x" from the MATLAB workspace to the "Calculate" variable.

Note Excel Macro Functions only support one output range. For MATLAB functions with multiple outputs, consider writing to multiple ranges directly.

      MLGetMatrix "x", "x"
      MLGetMatrix "y", "y"

MATLAB: Is the current folder different when I start MATLAB R2017a

There has been a change in MATLAB R2017a which affects the MATLAB startup folder.

Up to R2016b, the default startup folder is set to the "userpath" variable, which is C:\Users\...\Documents\MATLAB for Windows. Starting with R2017a, the default startup folder will be the last folder you were working in.

If you wish to change this setting, you can do so by clicking on "Preferences" in the "HOME" tab of the top ribbon, going to MATLAB\General, and changing the "Initial Working Folder" value from "Last working folder from previous MATLAB session" to "C:\Users\...\Documents\MATLAB"

According to the new default setting, if you closed MATLAB while working in C:\windows\system32, then that is the folder MATLAB will start in when you start it again.

Alternatively, you might be getting this behavior because of the configuration for the icon you use to start MATLAB. Please right-click on the icon and select Preferences, and make sure that the option for "Start In:" is blank. If this option is set to a directory, MATLAB will ignore your startup folder preferences and start in the directory specified in the shortcut icon.

Best Answer

Related Solutions

MATLAB: How to use Excellink functions in a Excel Macro Function instead of a Sub

MATLAB: Is the current folder different when I start MATLAB R2017a

Related Question