Info

This question is closed. Reopen it to edit or answer.

Question regarding the Spredsheet link EX tool, MLGetMatrix function

1 view (last 30 days)
John
John on 23 Feb 2013
Closed: MATLAB Answer Bot on 20 Aug 2021
Hello,
I have a question regarding the Spreadsheet Link EX tool.
I have been trying to use the code below in a loop in a VBA macro to pass 3 cells in excel as inputs into a fuzzy logic model in Matlab. I can see in Matlab the output being correctly computed in the workspace but the value is not printed into the cell in excel.
I know for sure that MLGetMatrix line is wrong. It works fine if I used a fixed cell such as MLGetMatrix "decision", sh1.Range("AJ5").Address but not if I use the current line below.
Could anybody tell me what I am doing something wrong with the MLGetMatrix function?
Thank you
Kind Regards
MLShowMatlabErrors "yes"
MLEvalString ("cd('T:\1-L1UYWP')")
MLPutMatrix "decision_inputs", sh1.Range(sh1.Cells(ii, k + 7), sh1.Cells(ii, k + 9))
MLEvalString ("decision =evalfis(decision_inputs,Model)")
MLEvalString ("decision =round(decision)")
MLGetMatrix "decision", sh1.Range(sh1.Cells(ii, k + 10)).Address '*** Output is not printed into cell***
MatlabRequest

Answers (1)

John
John on 25 Feb 2013
bump

Community Treasure Hunt

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

Start Hunting!