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

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?

Answer 1

[Monika Jaskolka]

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);