- Use the From Spreadsheet block in Simulink to read data from Microsoft® Excel® and outputs the data as a signal. Here is a Blog post giving further details on Importing Data From Excel into a simulation using the From Spreadsheet Block.
- Use the importdata function in MATLAB and create an array (say ‘A’) of all the values imported and then change the variable name in each block to A(1), A(2),…….A(100)
- Or similarly, use the Import Tool to import data from a spreadsheet into the MATLAB workspace.