Simulink - Excel

2011 4 27
6 个回答
更新时间：2022 2 10
9 次查看（30 天）

0 个投票

Hello
Does anyone know if it's possible to run an excel file in Simulink? I have a column with a variable in excel, and don´t know if there is a block that I can get in simulink to run this variable.
Regards

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

回答（6 个）

Guy Rouleau
Guy Rouleau 2011-4-28
编辑：John Kelly 2014-8-22

1 个投票

The Signal Builder block allows you to import a signal directly from Excel:
http://www.mathworks.com/help/simulink/slref/signalbuilder_cmd.html
Arnaud Miege
Arnaud Miege 2011-4-27

0 个投票

What do you mean "run this variable" and why do you need to do that? Depending on what you want to do, it might easier to just import the data in MATLAB using xlsread and then use the From Workspace block to use the variable in the Simulink model.
HTH,
Arnaud

2 个评论
显示 无 隐藏 无

Pat
Pat 2011-9-5
i have a variable b which consists of values [ 2 3 4].if i enter b to pass these values to fuzzy logic controller as input i get an error.can any one help
the error is 'expression b does not evaluate to valid FIS'
Sajjad Khan
Sajjad Khan 2022-2-10
I have been facing the same problem. Could some one explain it?

请先登录，再进行评论。

Tiago
Tiago 2011-4-27

0 个投票

Thanks to booth for your replay.
I import to workspace. I see the block Arnaud said.
Now... What I put in data in block parameters?

9 个评论
显示 7更早的评论 隐藏 7更早的评论

Arnaud Miege
Arnaud Miege 2011-4-27
Read the documentation. It depends on the format of your data in the workspace, but typically something like [time_vec data_vec], where time_vec is the name of your time vector and data_vec is the name of the your data vector. Both vectors need to be the same size, and need to be column vectors (Nx1).
Tiago
Tiago 2011-4-27
well... I try but can´t make that work.
Anyone have any example or tutorial to I see how this work?
Arnaud Miege
Arnaud Miege 2011-4-27
It's not particularly difficult. What's your data like? Can you copy and paste the output of whos at the command line? What error message are you getting?
Tiago
Tiago 2011-4-27
I will try explain step by step to you understand me and my error.
I have two columns in excel: Time and Values
Import the file to workspace. Stand now with two files: data and textdata.
Next what I need to do?
Gia
Gia 2011-4-27
Hi Tiago,
The variable data should contains all numerical values of your excel file -- a time column and a data column.
You can create a look up table using time as x-axis. Feed the clock as input.
Tiago
Tiago 2011-4-27
yes, I have in file data per example 22x2. 2 columns with 22 values.
My question is how make simulink run that.
Using the "simin" right?
Arnaud Miege
Arnaud Miege 2011-4-27
Assuming your time values are in the first column, you just need to enter data in the block (if data is the name of your variable).
Tiago
Tiago 2011-4-27
not understand..
In simulink I put per example:
simin x constant = simout ??
Arnaud Miege
Arnaud Miege 2011-4-28
Instead of simin, just enter the name of your variable, i.e. 'data' in your case (without the quotes) and that's all there is to it!!

请先登录，再进行评论。

Tiago
Tiago 2011-4-28

0 个投票

Thanks all for your help. I´m a noob in Simulink, it´s my first contact with this software, I need to go step by step if not I get lost.
In Simulink I put per example simin x constant = simout, is right that part?

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Arnaud Miege
Arnaud Miege 2011-4-28
Why do you want to do simin x constant? What are you trying to achieve? You may want to look at the Simulink tutorials at:
http://www.mathworks.co.uk/academia/student_center/tutorials/simulink-launchpad.html
and also read the documentation.
Tiago
Tiago 2011-4-28
I don´t now if the correct way is simin x constant. I have one constant and one file in excel with one variable with time. And want multiply this variable by the constant over time.
Arnaud Miege
Arnaud Miege 2011-5-3
Did you have a look at the tutorials I suggested? You really need to get up to speed with the basics of Simulink. Have a look at the following snapshot:
https://picasaweb.google.com/lh/photo/e5izz3VrVIYHyZnnq3oc6A?feat=directlink

请先登录，再进行评论。

Tiago
Tiago 2011-6-1

0 个投票

Hello
Sorry don´t say more nothing but I was out of office in last days. In this moment I still don´t know how to solve this problem.
I understand for you guys it is very simple, but for me it is a hell :)
For example I have in workspace: Time 1 2 3 4 5 Values 5 8 9 4 2
And need multiplicate this values with a constant
What blocks I need to use to make that operation?
Best Regards

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Arnaud Miege
Arnaud Miege 2011-6-1
Again, have a look at the snapshot I mentioned in my earlier comments, read through the documentation and look at the tutorials I pointed you towards. This is really basic stuff. Failing that, you need to go for a training course:
http://www.mathworks.co.uk/services/training/courses/SLBE_1.html

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

提问:

Tiago
Tiago
2011-4-27

评论：

Sajjad Khan
Sajjad Khan
2022-2-10

Community Treasure Hunt

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

Start Hunting!

Translated by