MATLAB Answers

From spreadsheet in simulink ....How to deal with inf problem

5 views (last 30 days)
Ill ch
Ill ch on 25 Sep 2019
Commented: Ill ch on 28 Sep 2019
Dear Simulink user,
i am using from spreadsheet block to uplad on simulink my signal. However i found there limitaions of spreadsheet block is it? anybody know solution to deal with from spreadsheet block?


Sign in to comment.

Accepted Answer

Ankit on 26 Sep 2019
Edited: Ankit on 26 Sep 2019
there is problem in your spreadsheet.
I would like to confirm that if your time values are correct.
You just need to replace the "." with ",". (Its german formatted excelsheet)
I just did the above changes and there is no error, model is able to simulate (just use the attached sheet) but my concern is with your time values which are to the power of 7.


Show 5 older comments
Ill ch
Ill ch on 27 Sep 2019
Thank you for your fast reply. 2018b conversion not possible in my laptop i tried but i am sending u screenshotUnbenannt.PNG
Ankit on 27 Sep 2019
Is there any reason you are using Variable-step solver?
One way you can avoid this is by setting the Sample time in Spreadsheet block to small value (for e.g. 1e-8) as your time values are very small.
The Sample time parameter specifies the sample time that the From Spreadsheet block uses to read data from the spreadsheet.
-1 value inherits the value the from the block into which the From Spreadsheet block feeds data.
Just for your understanding try changing the sample time from 1e-5, 1e-7 and 1e-8 and see the corresponding plots.
I think most of your settings are auto. I would recommend you go through this page:
All the best!
Ill ch
Ill ch on 28 Sep 2019
no there are not any reason. I will try it . Thank you very much
if i will have any question will late you know

Sign in to comment.

More Answers (0)