Importing Data to Simulink with Dates

Question

Klaudia Kello 2023-10-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2039091-importing-data-to-simulink-with-dates

回答： Varun 2023-10-31

I have an Excel spreadsheet that contains data for a full year, detailing both solar production and consumption values for specific dates.

How can I import this data into Simulink? Within Simulink, I intend to perform subtraction on these two parameters.

The primary objective is to utilize solar energy to charge a battery storage system and monitor its capacity to determine when it's fully charged.

I've attached the Excel file and the relevant Simulink blocks for your reference.

Thank you for your assistance

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

请先登录，再进行评论。

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

Answer 1

Varun 2023-10-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2039091-importing-data-to-simulink-with-dates#answer_1344006

Hi Klaudia,

I understand that you want to import an excel spreadsheet in the Simulink that contains data for a full year, detailing both solar production and consumption values for specific dates.

To accomplish this task, you can use "From Spreadsheet" block in Simulink. Ensure that you change datatype of date in excel to number, as date formats are not supported. The "From Spreadsheet" block reads data from Microsoft® Excel® (all platforms) or CSV (Microsoft Windows® platform with Microsoft Office installed only) spreadsheets and outputs the data as a signal.

To learn more about "From Spreadsheet" block, please refer to the following documentation:

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

You can also refer to this nice blog "Importing Data From Excel" using "From Spreadsheet" block.

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