How can I set 'file name' and 'sheet name' as variables in 'from spreadsheet' block in simulink

2 visualizzazioni (ultimi 30 giorni)
Hi,
I'm trying to import timeseries data saved as '.xlsx' to simulink.
As my first step, I have attempted to use 'from spreadsheet' block, then it works well.
Here, I wrote a real file name (ex. 'test.xlsx') in 'file name' box.
But, I want to define it as variable (ex. input_xlsx = 'test.xlsx', then input_xlsx in 'file name' box).
Is there any solution?

Risposta accettata

Monika Jaskolka
Monika Jaskolka il 20 Mar 2020
Modificato: Monika Jaskolka il 20 Mar 2020
Is it not possible to do this from the GUI, but you can do it from the command line:
blk_pathname = 'testModel/From Spreadsheet';
input_xlsx = 'test.xlsx';
input_sheet = 'Sheet1';
set_param(blk_pathname, 'FileName', input_xlsx);
set_param(blk_pathname, 'SheetName', input_sheet);

Più risposte (0)

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Prodotti


Release

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by