Test Manager Input Starting of the Second Row

3 visualizzazioni (ultimi 30 giorni)
I am using the Test Manager within Simulink and have my inputs in an excel file.
The excel data has a header in the first couple of rows before the actual data starts.
When I try to map it I get the error: Empty data found after time column at end of sheet 'input' of file.
Is it possible to map data that does not start on the first row of and excel file?

Risposta accettata

Paul Urban
Paul Urban il 14 Apr 2020
It is possible to specify a range of cells to use in the Test Manager. In the inputs section of the Test Manager, select the excel that was input. Select the arrow to the right of the Edit operation to select Edit Input Mapping. Or click on the hyperlink under the Sheets column in External Inputs. Under "Sheets and/or Range Specification" you can put in the row to start from in the Ranges column. For example, set the range to A3 to specify that the data starts there if you have 2 header rows. You can also specify the exact range of your data for example A3:G20.
There also is an api command to do this documented here: addExcelSpecification

Più risposte (0)

Prodotti


Release

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by