Signal Builder and Importing Data from Excel

Question

Fraser Lloyd 2019-8-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/475976-signal-builder-and-importing-data-from-excel

评论： Eghosa 2023-3-21

VariableSOCLIBCircuit.slx

Hi all,

Using the attached simscape circuit, I am trying to use the signal builder to import current values generated from excel. When doing so, I am met with the message telling me that my excel file is not compatible. I was wondering if anyone could give me some help with this?

Thanks,

Fraser

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

请先登录，再进行评论。

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

Answer 1

Samatha Aleti 2019-8-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/475976-signal-builder-and-importing-data-from-excel#answer_387808

Hi,

For the excel sheet to comply with Signal builder while importing, it should not contain non-numeric values. So, try not using non-numeric values in your excel sheet.

Following is the link for a blog, which also covers importing excel sheet into Signal Builder:

https://blogs.mathworks.com/simulink/2011/01/12/creating-test-cases-using-signal-builder/

2 个评论
显示无隐藏无

Fraser Lloyd 2019-8-18

Hi,

Thanks for taking the time to answer. I am unsure as to what you mean by using non-numeric values? How can I change numeric values to non-numeric values in excel?

I have looked at the blog you attached and I was unable to get any further.

Thanks

Eghosa 2023-3-21

Had similar challenges and was able to resolve it by deleting about 10 of the empty column close the filled column. Either by omisssion or during the process of copying the irradiance and temperature data empty column after the filed colums were either populated with dots, prompting the error message (non -numeric values ).

Droping this here for future references.

请先登录，再进行评论。