Transforming cell from excel file into numeric matrix
4 views (last 30 days)
Show older comments
Ahmad Fakih
on 17 Jan 2020
Commented: Ahmad Fakih
on 17 Jan 2020
I'm trying to transform a number from an excel file cell located at (381,6) into a 1 by 1 numeric matrix. I'm trying to use this code but its not working. Any help please. Below is my code and I'm sure I have done some unnecessary steps.
T=readtable('Output_1.xls');
T1=T{:,:};
displ=T1(381,6);
displ_final(i,1)=cell2mat(displ);
2 Comments
Accepted Answer
KALYAN ACHARJYA
on 17 Jan 2020
Edited: KALYAN ACHARJYA
on 17 Jan 2020
Exactly, readmatrix is preffered, if you have latest version. If not you can try the following one
T=xlsread('Output_1.xls');
disp(T(381,6));
I have cheked with sample file, it works.
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!