Index exceeds matrix dimensions Error
显示 更早的评论
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);
采纳的回答
Walter Roberson
2018-9-19
0 个投票
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
2018-9-19
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
