Simulink- From Spreadsheet function Errors

I'm attempting to use a .xlsx file to replay a one column of data but I seem to encounter an error which can be seen below.

Error:Error encountered in block XXX/From Spreadsheet

Caused by:

The sheet contains either empty signal headings or leading/trailing blank cells. For the header row, either provide values for each column or clear the values for all the columns.

This error is very new to me as the model was working as expected 2 days ago, yet on reopening it now throws the above error even though nothing has changed.

Here are the block parameters

Answer 1

[Akshat]

Hi @Simon

I understand that you are experiencing issues while using the 'From Spreadsheet' block. From what I understand, the error reflects the usage of a mal-formatted spreadsheet. To ensure accurate functioning, the data that the 'From Spreadsheet' block reads from a spreadsheet must be appropriately formatted. Please take in consideration the following points to abide to the correct format for the spreadsheet.

• The 'From Spreadsheet' block interprets the first row as a signal name. If signal names are not specified, the block assigns a default name 'Signal #', where '#' increments with each additional unnamed signal.
• The 'From Spreadsheet' block interprets the first column as time whose values must monotonically increase.
• The 'From Spreadsheet' block interprets the remaining columns as signals.

Further, it should be ensured that the selected worksheet is within the filepath and the correct 'Range' is chosen so that the blank cells are omitted and correct data is generated at output.

Read more about 'From Spreadsheet' block: https://in.mathworks.com/help/simulink/slref/fromspreadsheet.html

I hope this helps.