how to input table data in look up table from simulink instantaneously
4 views (last 30 days)
I have a simulink model and i need to input look up table from the simout file in waorkspace during the cource of simulation .Hence how can i input "table data" in look up table from simulink instantaneously.As given in the below MAtlab documentation
This example shows how to use the MATLAB xlsread function in a Simulink model to import data into a lookup table.
- Save the Excel® file in a folder on the MATLAB® path.
- Open the model containing the lookup table block and in the Modeling tab, select Model Settings.
- In the Model Properties dialog box, in the Callbacks tab, click PostLoadFcn callback in the model callbacks list.
- Enter the code to import the Excel Spreadsheet data in the text box. Use the MATLAB xlsread function, as shown in this example for a 2-D lookup table.% Import the data from Excel for a lookup table
data = xlsread('MySpreadsheet','Sheet1');
% Row indices for lookup table
breakpoints1 = data(2:end,1)';
% Column indices for lookup table
breakpoints2 = data(1,2:end);
% Output values for lookup table
table_data = data(2:end,2:end);
- Click OK.
After you save your changes, the next time you open the model, Simulink® invokes the callback and imports the data.
HEre i have used simout and it produces a 1 x 1 double timeseries data according to the simulation time.How can i use this data as an input to the look up table as mentioned in the below documentation ?
Sulaymon Eshkabilov on 3 Sep 2021
It looks like that you have 1D look up table data imported from MS Excel. Thus, you'd need to use 1D lookup table and just connect the output ports of MS Excel block with the input port of 1D lookup table. See this help doc: https://www.mathworks.com/help/simulink/slref/1dlookuptable.html
It is quite straightforward, once you set up [From MS Excel] data block settings.