Importing excel spreadsheet into Simulink (configuration parameters pane)
5 views (last 30 days)
Show older comments
Hi
I have a question regarding importing data from excel spreadsheet into the Simulink inport. I have 1 sheet with 54 column, the first column corresponds time and the rest are time dependent parameters. As I found out, first I should convert the excel file into the mat file and then import it from configuration parameters>> Data import/export. The problem is that I don't see any place called edit data as I see in other versions, (I am using a rather old version of Simulink). I attached a print screen of that page from both versions. I really appreciate if you would give me a hint regarding that.
Best Regards, Elham
0 Comments
Answers (2)
Sean de Wolski
on 18 Dec 2013
Could you just import it into MATLAB (completely outside of Simulink) using the Import tool or importdata or xlsread and then write it to a MAT file from there?
4 Comments
Sean de Wolski
on 18 Dec 2013
In the model properties -> callbacks, run:
load mydata.mat;
And then put the variable name that's inside of mydata.mat where you have the input now.
Elham
on 19 Dec 2013
2 Comments
Tejendra Shrestha
on 4 Jan 2018
Gr8 that you solved. I've similar situation but cannot achieve it. i've 3 input for fuzzy logic controller; listening, oral_communication, written_comunication. I have made 3 columns in excel and have a single sample row. how do i input the three columns data into 3 respective inputs in simulink. Plz help me...
See Also
Categories
Find more on Sources in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!