Transforming cell from excel file into numeric matrix

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

Using a table seems superfluous, did you try readmatrix?:
I think readmatrix is exclusive to 2019b version, mine is 2018a :(

댓글을 달려면 로그인하십시오.

 채택된 답변

KALYAN ACHARJYA
KALYAN ACHARJYA 2020년 1월 17일
편집: KALYAN ACHARJYA 2020년 1월 17일
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.

추가 답변 (0개)

카테고리

태그

질문:

2020년 1월 17일

댓글:

2020년 1월 17일

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by