Calling a Matlab Function in Simulink which integrates Data from Excel when Stateflow State is active

Question

Vincent Perner 2017-11-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/368555-calling-a-matlab-function-in-simulink-which-integrates-data-from-excel-when-stateflow-state-is-activ

回答： Vignesh 2017-12-19

Hey Guys,

i am trying to build a Simulink model of a manufacturing line. As powerload profiles are of interest i tried to simulate the current power used by the machines, therefore i developed a stateflow chart with five states (off,deactivated,standby,operational,working). Each state is associated to a typical load profile which was measured and stored in severel excel sheets. I now try to develop a function which is called when, for example, working state is active. The function shall read the first row and second column of the associated excel data(first column is time, not equal to simulation time!) in the first time step when state working is active and the second value in the second time step of simulation etc... Do you guys know how to do it? I tried programming a matlab function using if,while,for loops, but non of these worked because the only read out the first value of the data sheet.

Kind regards, Vincent