Excel data import in simulink

I wanted to add data in simulink from an excel file. I get the error" 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."

[Bibek]

I had the same issue in 2021b. I did the following which helped.

1. ensured the selected worksheet is within the filepath
2. created a new worksheet tab for input data only
3. deleted the colum headers (time, etc), the data would start from A1:xx

Still I am not sure, why I got the issue as the other spreasheets worked fine regardless of the changes above.

[YURIY]

Спасибо! Именно третье замечание стало ключевым, из-за него всё!

Answer 1

[Akhilesh Mishra]

Please refer to the 'Range' section in the following documentation link for 'From SpreadSheet' block. If you have blank cells in the excel sheet you can omit them by specifying the correct indexing.

https://www.mathworks.com/help/simulink/slref/fromspreadsheet.html#bvbjvvu

[Ramakrishnan Vaidyanathan]

Thank you for the answer. I shall follow. Ramakrishnan V