MATLAB Answers

Transforming cell from excel file into numeric matrix

3 views (last 30 days)
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

Ahmad Fakih
Ahmad Fakih on 17 Jan 2020
I think readmatrix is exclusive to 2019b version, mine is 2018a :(

Sign in to comment.

Accepted Answer

KALYAN ACHARJYA
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)

Sign in to answer this question.


Translated by