Error in 'From Spreadsheet ' Block in Simulink

I have 4948 samples in the excel sheet with two columns, first column to be treated as time ad second column to be treated as data. But as soon I press OK after linking the spreadsheet to 'From Spreadsheet' block it results into so many ports instead of just one data port. Tried on MATLAB 2018b.

Thank You in Advance.

Answer 1

[Sugar Daddy]

Because the sheet you are feeding is row vector (i.e. it has 1 row and 4948 columns), while MATLAB requires column vector (i.e. 4948 rows and 1 column). So take transpose of excel sheet

[DARSHAN N KANNUR]

Yeah, as you can see first column is treated as time ad second column is treated as data.

[Sugar Daddy]

so is the problem resolved?

[DARSHAN N KANNUR]

not yet

[Sugar Daddy]

when you select Sheet1 of test1.xlsx

you will see this

change it to Sheet2

[DARSHAN N KANNUR]

Actually there is another problem while rumming the simulation. Help me out.

[Sugar Daddy]

open excel file vel.xlsx. what is the name of sheet? if it is Sheet1 replace Sheet1 in from spreadsheet block

For example

The file i provided has 2 sheets i.e. Sheet1 and Sheet2

Now suppose that i change the Sheet1 name in excel to My_sheet1 and now run the code

The error will occur that Sheet "Sheet1' not found.

So in such a case what should i do, i need to tell from spreadsheet block to read My_sheet1 which exists in excel and not some non existing sheet

Double click from spreadsheet block and change sheet name to the new name of your Sheet

[DARSHAN N KANNUR]

when i changed the name of the sheet to sheet2, again the same type of problem block with so many ports.like i have mentioned in the first doubt.

[Sugar Daddy]

please attach the sheet if possible

[DARSHAN N KANNUR]

Hello sir I have attached the excel sheet. Do check it.

Edit Rik:

Moved attachment from separate answer to this comment.