- Substitute all NaNs with "0"s or something else with relational operator before using/feeding the data to the Simulink model.
- A bit more complicated way is to use logic and bit operators to sort out all NaNs.
How to deal with NaN in 'from spreadsheet' block in Simulink? How do I make Simulink ignore NaNs?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a spreadsheet which has certain 'NaN' values under different variables. This spreadsheet is exported from MATLAB.
I am using the spreadsheet to export values of Irradiance and temperature to a Simulink PV model. The model screenshot is attached:
![Cadddddddpture.JPG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/235241/Cadddddddpture.jpeg)
I am using 'from spreadsheet block' from the Simulink library.
The spreadsheet data looks like this
![Captxsure.JPG](https://www.mathworks.com/matlabcentral/answers/uploaded_files/235242/Captxsure.jpeg)
While running the model I am getting the following errors:
![5dtrt.png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/235243/5dtrt.png)
How do I make SIMULINK ignore the NaN values and run the simulation?
0 commentaires
Réponses (1)
Sulaymon Eshkabilov
le 28 Août 2019
Hi,
I would suggest to try two different ways:
Good luck
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!