Index exceeds matrix dimensions Error

Question

Ji Li 2018-9-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/419606-index-exceeds-matrix-dimensions-error

评论： Walter Roberson 2018-9-19

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 个评论
显示无隐藏无

Walter Roberson 2018-9-18

The first line is not MATLAB code?

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.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2018-9-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/419606-index-exceeds-matrix-dimensions-error#answer_337389

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

Oh, You’re right! They are Boolean values in the three cells (TRUE/FALSE). But how could them be read into Matlab?

Walter Roberson 2018-9-19

在 MATLAB Online 中打开

   [~, ~, 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};