How to import constant data from an Excel sheet into Simulink

7 views (last 30 days)
I have 12 real sensors as input blocks in Simulink. After calibrating the sensors relative to the first one, I get twelve factors that I need to scale the signals with, so that all sensors output the same value, when subjected to a signal of the same strength.
This calibration takes place once every day or two, so I don't want to hard-code the correction factors into my Simulink model. Instead, I would like to read them from an Excel-file.
The "From Spreadsheet" - Block gives me the possibility of reading data, however, it seems to be designed primarily to read signals from a spreadsheet. Since this is not the case, I don't quite know how to deal with the issue.
Additional info: I am using Simulink for a high-speed real-time-control application, so efficiency is essential.

Accepted Answer

Fangjun Jiang
Fangjun Jiang on 6 Dec 2023
Use Constant blocks to specify these values in the Simulink model. Use Variables to specify the value for those Constant blocks. Use PreLoadFcn or InitFcn callback of the model to read Excel file and create those variables.

More Answers (0)

Categories

Find more on Event Functions in Help Center and File Exchange

Products


Release

R2023b

Community Treasure Hunt

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

Start Hunting!