How to import constant data from an Excel sheet into Simulink

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.

Answer 1

[Fangjun Jiang]

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.