How can I set 'file name' and 'sheet name' as variables in 'from spreadsheet' block in simulink
8 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Kouta Amano
le 17 Mar 2020
Modifié(e) : Monika Jaskolka
le 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 commentaires
Réponse acceptée
Monika Jaskolka
le 20 Mar 2020
Modifié(e) : Monika Jaskolka
le 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!