How can I set 'file name' and 'sheet name' as variables in 'from spreadsheet' block in simulink
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Kouta Amano
il 17 Mar 2020
Modificato: Monika Jaskolka
il 20 Mar 2020
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?
0 Commenti
Risposta accettata
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);
0 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Data Import from MATLAB in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!