MATLAB Answers

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

6 views (last 30 days)
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 Comments

Sign in to comment.

Accepted Answer

Monika Jaskolka
Monika Jaskolka on 20 Mar 2020
Edited: Monika Jaskolka on 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 Comments

Sign in to comment.

More Answers (0)

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by