Input Excel Data into simulink without time.

5 views (last 30 days)
Hi Mathworks community!
I'm getting started on Simulink and I'm finding a couple of diffculties. My Simulink model is just mathematic and I don't need to simulate with time signals input, only numeric data (arrays, matrixes, scalars). I'll be using matlab function blocks with code of my own. The main issue I have is with the From Spreadsheet block. I've been reading some documentation about this block, and the first column of my excel file is always interpeted as a time variable and I can't seem to find a way to read the whole range as a Matrix.
I'm awared that I can use a constant input and write manually a matrix or array but I'll be working with large data, soy this ain't a valid solution for this case.
Can someone give me a hand?
Thank you!

Accepted Answer

Sunand Agarwal
Sunand Agarwal on 25 Feb 2021
For the 'From Spreadsheet' block to consider the first column of your Excel file as a vector, you may open the dialog window by double clicking on the block and you should see an option called 'Treat First Column as'. If you set the option to 'Data', which by default is set to 'Time', the first column will be treated as a vector and it will do the trick.
Hope this helps.

More Answers (0)


Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!