Simulink- From Spreadsheet function Errors

Question

Simon 2023-9-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2026924-simulink-from-spreadsheet-function-errors

编辑： Akshat 2023-10-1

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Akshat 2023-10-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2026924-simulink-from-spreadsheet-function-errors#answer_1323104

编辑：Akshat 2023-10-1

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.