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

11 次查看（过去 30 天）
Kouta Amano
Kouta Amano 2020-3-17
编辑： Monika Jaskolka 2020-3-20
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?

请先登录，再回答此问题。

采纳的回答

Monika Jaskolka
Monika Jaskolka 2020-3-20
编辑：Monika Jaskolka 2020-3-20
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Interactive Model Editing 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by