清空筛选条件
清空筛选条件

simulink use date.xlsx?

1 次查看（过去 30 天）
li xinjun
li xinjun 2012-4-6
I have made an Subsystem in simulink,and which has 4 inputs:Type,L,W and H.Now I have an Excel file which records about more than 10000 Types,and for each Type has its L,W and H. In this data.xlsx ,the data has 4 columns.I wish the 4 inputs of this subsystem are "edit"(I can enter by myself).And when I input a type name in "Type" ,the simulink can search in the first column in data.xlsx,if find the same type ,it can read the corresponding L,W and H from data.xlsx to the "edit" dialog of L,W and H on the subsystem input dialog.But when it can't find the same Type, it needs User to continue edit the rest 3 data and it can save this 4 data to data.xlsx automatically .I think this is very hard to get,How can I do I haven't find it? Thank you.

请先登录，再回答此问题。

采纳的回答

TAB
TAB 2012-4-9
There is no block to directly read or manipulate .xlsx files from simulink.
For this requirement, write MATLAB code which implements xlsx reading searching algorithm and pass the code output to simulink through base workspace or mat-file.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Interactive Model Editing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by