Excel data import in simulink

Question

Ramakrishnan Vaidyanathan 2017-7-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347330-excel-data-import-in-simulink

评论： Bibek 2023-2-14

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."

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Bibek 2023-2-14

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

ensured the selected worksheet is within the filepath
created a new worksheet tab for input data only
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.

请先登录，再进行评论。

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

Answer 1

Akhilesh Mishra 2017-7-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347330-excel-data-import-in-simulink#answer_273718

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