Index exceeds matrix dimensions Error

1 次查看(过去 30 天)
I have a function which writes inputs from Excel. The function doesn't report any errors in Matlab, but when I converted it into an Excel add-in, it tells me "Index exceeds matrix dimensions". The error occurs at the "Horizon" line in the code. How can I find out what the problem really is?
Inputs InputsData = xlsread(inputFileName, 'Portfolio', 'U4:U15');
N = InputsData(1);
K = InputsData(2);
PERC = InputsData(3);
PERC_T = InputsData(4);
GLOB = InputsData(5);
COUT = InputsData(6);
SEC = InputsData(7);
FI = InputsData(8);
LIMIT = InputsData(9);
HORIZON = InputsData(10);
ALC = InputsData(11);
CUT = InputsData(12);
  2 个评论
Ji Li
Ji Li 2018-9-19
No, it is code. Sorry I should’ve deleted the first word “Inputs”. Also, “inputFileName” is predefined, it refers to my Excel file name.

请先登录,再进行评论。

采纳的回答

Walter Roberson
Walter Roberson 2018-9-19
For whatever reason, U13, U14, and U15 are not present in the returned data. That could occur with that code if the values in those locations are all not numeric, as well as for the case where those values all just do not exist.
  2 个评论
Ji Li
Ji Li 2018-9-19
Oh, You’re right! They are Boolean values in the three cells (TRUE/FALSE). But how could them be read into Matlab?
Walter Roberson
Walter Roberson 2018-9-19
[~, ~, InputsRaw] = xlsread(inputFileName, 'Portfolio', 'U4:U15');
N = InputsData{1};
K = InputsData{2};
PERC = InputsData{3};
PERC_T = InputsData{4};
GLOB = InputsData{5};
COUT = InputsData{6};
SEC = InputsData{7};
FI = InputsData{8};
LIMIT = InputsData{9};
HORIZON = InputsData{10};
ALC = InputsData{11};
CUT = InputsData{12};
I do not know what datatype HORIZON, ALC, and CUT will come out as.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Portfolio Optimization and Asset Allocation 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by