MATLAB: How to generate signal from microsoft excell dataset at Simulink

importing excel datasignalSimscape Electricalsimulink

Hello everyone I have a problem about Simulink.Now I have Real Power Profile data.(time-dependent power chart) .This is in the excell file. I want to use this data as a signal at Simulink.So,I want to generate a signal from this data. How can I do it ? I need help. Thank you.

Best Answer

A few options depending on your situation:

1. Get the Simulink Tester toolbox. It can work with Excel spreadsheet directly.

2. Pre-process your Excel file. Write a script to import your Excel data into MATLAB workspace or save it to a .mat file. The primary function is xlsread().

3. If it is one-time, you can run uiimport to import the Excel data into MATLAB workspace.

4. You can record your interaction using uiimport in a script. This can help you develop the script.

Related Solutions

MATLAB: How to use from workspace block

Since R2015b, Simulink supports the From Spreadsheet block.

From Spreadsheet can read Excel files directly and output signals to Simulink.

See the documentation for details. : From Spreadsheet

Sample model is as attached.

MATLAB: Read Excel sheet (one after other )

The second output of xlsinfo can tell you the names of all of the sheets. You can then loop over them with xlsread

filename = 'YourInputFile.xls';
[~, sheets] = xlsinfo(filename);
num_sheets = length(sheets);
data = cell(num_sheets, 1);
for K = 1 : num_sheets
  data{K} = xlsread(filename, sheets{K});
end

Best Answer

Related Solutions

MATLAB: How to use from workspace block

MATLAB: Read Excel sheet (one after other )

Related Question