Running Matlab script from Excel

12 Ansichten (letzte 30 Tage)
Dhana Raj
Dhana Raj am 5 Jul. 2011
I have a Matlab m-file that I would like to execute from Excel. How do I write the Excel VBA code to do so?
I have Spreadsheet Link EX installed and I am able to import and export values between Excel and Matlab, but I can't seem to find an easy way to run my custom m file.

Akzeptierte Antwort

Chirag Gupta
Chirag Gupta am 5 Jul. 2011
With the spreadsheet Link EX installed, you should be call your custom MATLAB code using the Add-in.
Click on MATLAB Add-in -> Run custom code -> Enter your function name
For doing so in VBA, refer to
  1 Kommentar
Dhana Raj
Dhana Raj am 5 Jul. 2011
Thanks. Tried this earlier, but it didn't seem to work. Works now after I fiddled around with the file paths where my script was located.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

Kaustubha Govind
Kaustubha Govind am 5 Jul. 2011
  2 Kommentare
Chirag Gupta
Chirag Gupta am 5 Jul. 2011
This will not utilize the already running Spreadsheet link
Dhana Raj
Dhana Raj am 5 Jul. 2011
Thanks for the suggestion.

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Data Export to MATLAB finden Sie in Help Center und File Exchange

Tags

Produkte

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by