Import excel file into simulink

16 views (last 30 days)
Mathubc khs
Mathubc khs on 9 Aug 2012
I have a simulink file as in a part of that I have put a gain that takes a constant number (0.12) from my mfile to calculate the cost. I want to put an excel file instead of that number that has 48 values( the values might change every one hour). How I can import this excel file? Thanks a lot
  1 Comment
Azzi Abdelmalek
Azzi Abdelmalek on 9 Aug 2012
do you mean, while your simulink model is runing, you update the value by importing it ?

Sign in to comment.

Answers (2)

TAB
TAB on 9 Aug 2012
Simulink directly can not interact with excel file.
Use a m-file to read the data from excel and pass this data to gain block parameter using simulink API interface.
For example
% Read the data from excel
GainValue = Data stored in the cell
% Update the model's gain block value
set_param('BlockPath','Gain',num2str(GainValue))
  1 Comment
Kaustubha Govind
Kaustubha Govind on 9 Aug 2012
You can use the XLSREAD command in MATLAB to read data from the Excel file.

Sign in to comment.


Azzi Abdelmalek
Azzi Abdelmalek on 9 Aug 2012
you can use an "intrpreted matlab fcn" block , with one constant input that does'nt matter, that pass through a 'zoh' block (with desired sample time : 3600s) and one output which will be the data updated.
function y=update_value(u);
y = xlsread('answer85.xlsx','a1:a1')
%in this case, you should run on real time which will possible only on normal mode

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!