MatLab does not reads Excel sheet properly

Question

MINATI PATRA 2024-2-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2081121-matlab-does-not-reads-excel-sheet-properly

评论： MINATI PATRA 2024-2-13

status = mkdir('D:\PK90');    cd D:\PK90
filename = 'sample111.xlsx'; T = readtable(filename);  
P = 2*T.A + 3*T.B + 4*T.C + 5*T.D + 6*T.E 

%% When running the Excel sheet, I want MatLab to read the values of all the parameters as varies in the sheet downward. When one parameter varies other values will be considered from first row.

4 个评论
显示 2更早的评论隐藏 2更早的评论

MINATI PATRA 2024-2-13

移动：Cris LaPierre 2024-2-13

sample111.xlsx

Sorry for the inconvinience.

Here is the excel sheet attached.

I want to run the code with variations of different parameters BUT when suppose I take values of 'A' as 2, 3 , values of other parameters are the default values (GREEN color, FIRST line values)

MINATI PATRA 2024-2-13

@

Dyuman

The sheet is in C: drive where MatLab is present, then result will be created in D:drive.

Actually this is part of the full code.

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2024-2-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2081121-matlab-does-not-reads-excel-sheet-properly#answer_1407868

移动：Cris LaPierre 2024-2-13

在 MATLAB Online 中打开

sample111.xlsx

readtable just loads the data as is. You will still need to write code to perform any manipulation to the data. Perhaps fillmissing does what you want?

d=readtable("sample111.xlsx")
d = 12×5 table
     A      B      C      D      E 
    ___    ___    ___    ___    ___

      1      2    0.5    0.1    0.1
      2    NaN    NaN    NaN    NaN
      3    NaN    NaN    NaN    NaN
      1      1    NaN    NaN    NaN
    NaN      3    NaN    NaN    NaN
    NaN      2      0    NaN    NaN
    NaN    NaN      1    NaN    NaN
    NaN    NaN    0.5    0.3    NaN
    NaN    NaN    NaN    0.5    NaN
    NaN    NaN    NaN    0.1    0.3
    NaN    NaN    NaN    NaN    0.5
    NaN    NaN    NaN    NaN    0.1
% replace NaNs with previous value
d = fillmissing(d,"previous")
d = 12×5 table
    A    B     C      D      E 
    _    _    ___    ___    ___

    1    2    0.5    0.1    0.1
    2    2    0.5    0.1    0.1
    3    2    0.5    0.1    0.1
    1    1    0.5    0.1    0.1
    1    3    0.5    0.1    0.1
    1    2      0    0.1    0.1
    1    2      1    0.1    0.1
    1    2    0.5    0.3    0.1
    1    2    0.5    0.5    0.1
    1    2    0.5    0.1    0.3
    1    2    0.5    0.1    0.5
    1    2    0.5    0.1    0.1