MATLAB: How to import excel datas to manage the Simulink blocks parameters

import dataimporting excel dataMATLABsimulink

Hello,

I have a Simulink model which contains nearly 100 blocks. Each of the blocks have "Amplitude" parameter. I want to choose all of the Amplitude parameters with importing data from an Excel sheet. For example;

Block 1; Amplitude= 25

Block 2; Amplitude= 21

Block 3; Amplitude= 26

…

Block 100; Amplitude= 17

I thought a solution like this:

Block 1; Amplitude= a1

Block 2; Amplitude= a2

Block 3; Amplitude= a3

…

Block 100; Amplitude= a100

These a1,a2,…,a100 parameters can be imported from MATLAB Workspace, which are created from Excel sheet, but I hope there is more easy way to do this. Thanks.

Best Answer

Hey,

There are two ways in which you can import excel data and use it in Simulink

Use the importdata function and create an array (say ‘A’) of all the values imported and then change the variable name in each block to A(1), A(2),…….A(100).
Use the MATLAB fcn blockin Simulink import the data using the importdata function and generate 100 outputs from that block or create a bus for the same and provide the input to the desired blocks.

Hope this helps!

Related Solutions

MATLAB: Input and excel sheet and output a different one

Hello Michel,

Create a GUI for the same. Add one Push Button, So that when you click on that Pushbutton, it will import the excel file (ABC.xlsx), it will read it, it will store the data into some Array variables, it will modify it as per your requirement, it will then write the modified data into another excel (XYZ.xlsx).

Code will be as follows:

 % --- Executes on button press in OK_.
function OK__Callback(hObject, eventdata, handles)
% hObject    handle to OK_ (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
 importData = xlsread('ABC.xlsx');
 modifiedData = 2 * importData + 100;
 xlswrite('XYZ.xlsx',modifiedData;
 winopen('XYZ.xlsx');

Note: The both excel files should be present in current directory.

MATLAB: How to import data files to column vectors in a loop

I don't know your importfile function, but in general you can do it the following way:

for fileNum = 1:numFiles
    fileName = sprintf('document%1d.xlsx',fileNum);
    [A(:,fileNum),B(:,fileNum),C(:,fileNum),D(:,fileNum),E(:,fileNum),F(:,fileNum),G(:,fileNum)] = importfile(fileName,sheet,range);
end

Best Answer

Related Solutions

MATLAB: Input and excel sheet and output a different one

MATLAB: How to import data files to column vectors in a loop

Related Question