Input Excel Data into simulink without time.

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!

Answer 1

[Sunand Agarwal]

Hello,

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.

[Santos García Rosado]

Thank you Sunand! It worked perfectly.