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:
You can also refer to this nice blog "Importing Data From Excel" using "From Spreadsheet" block.
