Hello Fairouz,
To read data from an Excel file, the 'readtable' function can be used. Below is a syntax on how to utilize this function. More information on the function, can be found in the documentation: https://www.mathworks.com/help/matlab/ref/readtable.html
filename = 'inputs.xlsx';
inputData = readtable(filename);
For creating a Simulink model with input blocks and modifying their parameters using a MATLAB script, here is an example to guide you through the process. In this example, the input from the Excel file includes the names for the 'Constant' blocks, their values, and their data types.
- Start by creating a Simulink model.
modelName = 'AutoGeneratedModel';
new_system(modelName);
open_system(modelName);
- Iterate over input data from the Excel file and add 'Constant' blocks to the model using the 'add_block' function. More information about this function can be found in the documentation: https://www.mathworks.com/help/simulink/slref/add_block.html .
- To set the name and data type of each 'Constant' block, use the 'set_param' function. More information about this function can be found in the documentation: https://www.mathworks.com/help/simulink/slref/set_param.html
for i = 1:height(inputData)
inputName = inputData.InputName{i};
dataType = inputData.DataType{i};
value = num2str(inputData.Value(i));
blockName = ['Constant', num2str(i)];
blockPath = [modelName, '/', blockName];
add_block('simulink/Sources/Constant', blockPath, 'MakeNameUnique', 'on');
set_param(blockPath, 'Name', inputName);
set_param(blockPath, 'OutDataTypeStr', dataType);
set_param(blockPath, 'Value', value);
end
- Re-arrange the blocks and save the model.
Simulink.BlockDiagram.arrangeSystem(modelName);
save_system(modelName);
close_system(modelName);
