MatLab does not reads Excel sheet properly
2 views (last 30 days)
Show older comments
MINATI PATRA
on 12 Feb 2024
Commented: MINATI PATRA
on 13 Feb 2024
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 Comments
Accepted Answer
Cris LaPierre
on 13 Feb 2024
Moved: Cris LaPierre
on 13 Feb 2024
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")
% replace NaNs with previous value
d = fillmissing(d,"previous")
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!