Integration of EXCEL in Simulink

Question

Maximilian Elias 2020-7-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/564665-integration-of-excel-in-simulink

回答： Jemima Pulipati 2021-2-20

Hello,

i have a problem when i want to read data from an EXCEL table, i use the SPREADSHEET block, as readout data, link the whole and DISPLAY to display the values.

The table looks like this as an example:

Column Values

Name 1 Value 1

Name 2 Value 2

Name 3 Value 3

In Simulink can not retrieve the names, although this is not the big problem.

However, I only get one value retrieved from the 2nd column and not all values.

The goal is to get the values from the Excel table in Simulink and process them further, ideally directly with the names, but if necessary I would simply assign a numerical value to each name.

Best regards

Max

Translated with www.DeepL.com/Translator (free version)

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

请先登录，再进行评论。

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

Answer 1

Jemima Pulipati 2021-2-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/564665-integration-of-excel-in-simulink#answer_628659

Hello,

From my understanding, you are facing an issue while reading data from a spreadsheet using the 'From Spreadsheet' block.

This block interprets the first row as signal names, first column as time and the remaining columns as signals. So you may consider storing the Excel data in this format. For more information please refer to the following link.

https://www.mathworks.com/help/simulink/slref/fromspreadsheet.html#buwt1zh-1

The following link describes an example on importing data from Excel.

https://blogs.mathworks.com/simulink/2019/03/15/importing-data-from-excel/