MATLAB: Mapping Test Harness Inputs to an Excel .xlsx File

boolean inputimport from excelmapping inputsMATLABsimulinksimulink testtest manager

The mathworks documentation( Importing Microsoft® Excel® Data ) shows how to map a .xlsx file to input ports in a test harness. This works fine if the input ports are doubles. However, if the input ports are boolean, the signal fails to map with the error: "Not compatible for simulation." I have tried using 0, 1 and TRUE, FALSE in the excel spreadsheet, but it still will not map. Is there a format for importing boolean data, or is this not supported?

Best Answer

Hi Trevor,

I understand from your description that you tried to map excel input data into boolean input port. The only data type supported in R2017a is double. Boolean type will be supported in R2017b, which will be released in September this year. But you can download a Prerelease trial from the following link to try this new feature:

https://www.mathworks.com/downloads/web_downloads/select_products

A workaround for this is what Swarooph suggested in the comment section. You can try 'Data Type Conversion' block to suite your need.

Related Solutions

MATLAB: How to load input data for a bus from an Excel sheet to a test harness model

To import data for a bus signal from an Excel sheet to a test harness model, the Excel sheet should be formatted as shown below:

The first column is Time and the other columns should represent the signals.

Timesignal_1(double)signal_Bus.VALVE1 (busSignalName.busElement)signal_Bus.VALVE2

(busSignalName.busElement)signal_Bus.a1(This is an Enum)

(busSignalName.busElement) Bus: CONTROL (Bus: busName) 0121One1241Two2361Three3481One Please note that the names for the output signals from the Input port in the test harness should match the column names in the Excel sheet.

Steps to map data from the Excel Sheet to the input ports: # Create a new test case. # Select the required model and test harness. # Under Inputs, click on Add and navigate to the required input Excel file. # Select the require sheet. # Select mapping method as “Signal Name”. # Click on “Map Inputs”. # Click on “Apply”. # Run the test case.

Please refer to the following documentation link for more information regarding specifying Excel file format for signal data:

https://www.mathworks.com/help/releases/R2018b/sltest/ug/specify-microsoft-excel-file-format-for-signal-data.html#mw_28ecc735-a873-49f0-bfe1-1e0dfb7921bb

MATLAB: How to import a test harness with an existing model reference

One way to do this is through sltest.harness.import, which allows you to import a stand-alone model as a test harness model.

If you created a harness using the "parent" model as the unit under test (similar to a model reference), use the "parent" model name as the 'ComponentName' in sltest.harness.import

Here is a simple example:

mainModel = 'UnlimitedFreeTacosModel'; % free tacos need not only be on Tuesdays
harnessModel = 'UnlimitedFreeTacosModel_harness'; % ensure this works on all the other days of the week
load_system(mainModel)
sltest.harness.import(mainModel,'ImportFileName',harnessModel,'ComponentName',mainModel,'Name',harnessModel(1:end-4));
save_system(mainModel)

Best Answer

Related Solutions

MATLAB: How to load input data for a bus from an Excel sheet to a test harness model

MATLAB: How to import a test harness with an existing model reference

Related Question