I understand that you want to extract rows from an excel file as Simulink parameters and add them as entries to a Simulink data dictionary. I was able to reproduce the error by creating a demo excel sheet with the specified parameter columns (containing all the required entries for ‘Simulink.Parameter’) with 11 rows.
The error is because of a type mismatch caused when the extracted entry from the excel sheet does not meet the required types defined for that particular ‘Parameter’ object property. For example, the ‘Parameter.Value’ property can only accept numeric and boolean values, enums, structs, scalars, arrays and mathematical expressions.
I’ve created a sample excel file as attached to demonstrate the working.
The code to add all the 11 entries as parameters into a data dictionary is given below:
myDictionaryObj = Simulink.data.dictionary.create('myDictionary2.sldd');
myDictionaryObj = Simulink.data.dictionary.open('myDictionary2.sldd');
toolDataSectObj=getSection(myDictionaryObj,'Design Data');
ParameterFile = readtable('test.xlsx');
for i = 1:height(ParameterFile)
param = Simulink.Parameter;
param.Value = ParameterFile.Value(i);
param.Max = ParameterFile.Max(i);
param.Min = ParameterFile.Min(i);
param.Description = char(ParameterFile.Desc(i));
param.Unit = char(ParameterFile.Unity(i));
addEntry(toolDataSectObj, char(ParameterFile.Parameter(i)), param);
end
The dictionary, after creation, looks like this:
Please find more information on ‘Simulink.Parameter’ objects here: https://www.mathworks.com/help/releases/R2022a/simulink/slref/simulink.parameter.html
Hope this helps!
