Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

Question regarding the Spredsheet link EX tool, MLGetMatrix function

1 vue (au cours des 30 derniers jours)
John
John le 23 Fév 2013
Clôturé : MATLAB Answer Bot le 20 Août 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

Réponses (1)

John
John le 25 Fév 2013
bump

Community Treasure Hunt

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

Start Hunting!

Translated by