How do I read in data from a spreadsheet to a Test Vector for a SystemTest of a Simulink Model, as datatype single?

I have the following error message, listing the source as "Simulink", in the Run Status box of SystemTest:

"Invalid data type for root level inport 'LimitSignal/Signal'. The model is configured to load its root level inports from the workspace. These external inputs must have data type 'double'. This data type does not agree with the data type, 'single', that is being set for this root level inport. Loading external inputs from the workspace is turned off by going to the Simulation menu and selecting Configuration Parameters. On the Data Import/Export page, locate the Load from workspace group and uncheck the Input checkbox."

The recommendation it gives does not work, as that checkbox is already unchecked.

Changing the Simulink model inputs to receive 'double' instead of 'single' prevents this error message, but can't I read in from the spreadsheet as 'single'?

Answer 1

[Fangjun Jiang]

You are using the SystemTest toolbox. It has some type of automation that can import data from Excel sheet behind the scene. I don't know how to resolve that problem. Maybe you can contact TMW tech support for help.

Without the toolbox, normally you would import the data into workspace and then use it in Simulink. It's easy to do the convertion in MATLAB.

Data=xlsread(ExcelFile);
Data=single(Data);

There got be some script that does the import so if you can find it, you can add the single() conversion. Again, calling TWM might be the easiest way to find it out.

[James]

Thanks for the suggestions.

I hoped importing my tests, and saving as a .mat file, would give me another mechanism for importing the data as a TestVector (the form it needs to be in to run the tests).

Each row of the spreadsheet is a test vector value, but the way SystemTest imports from .mat files is different - it looks for variables in the files.

[Fangjun Jiang]

You can import the data yourself. Use the xlsread() to read the Excel sheet and assign proper variable names for the data. Then use save() to save the data to a .mat file.

[James]

Thank you :).

I put this in a MatLab script in PreTest:

time = xlsread('Tests.xls', 'A2:A22');

signal = xlsread('Tests.xls', 'B2:B22');

expectedOutput = xlsread('Tests.xls', 'E2:E22');

signal = single ( signal ) ;

expectedOutput = single ( expectedOutput ) ;

save MatFiles/Tests.mat time signal expectedOutput

Then I read Tests.mat as a Test Vector during the test.

[Fangjun Jiang]

Good! One more thing to recommend is to do xlsread() once because running it multiple times is in-efficient. Once the data is read in, you can use MATLAB operation to split data into the variable names you want.

data=xlsread('test.xls');

time=single(data(1:21,1));

signal=single(data(1:21,2));

...

[James]

Many thanks!

Another solution:

I have discovered the Design Verifier generates a test harness model that wraps the component under test, and the data conversion is automatically inserted there (admittedly due to it using Signal Builder to provide the inputs).

The same technique could be done for this.