MATLAB Answers

Transforming cell from excel file into numeric matrix

조회 수: 3(최근 30일)
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

Stephen Cobeldick
Stephen Cobeldick 17 Jan 2020
Using a table seems superfluous, did you try readmatrix?:
Ahmad Fakih
Ahmad Fakih 17 Jan 2020
I think readmatrix is exclusive to 2019b version, mine is 2018a :(

로그인 to comment.

채택된 답변

KALYAN ACHARJYA
KALYAN ACHARJYA 17 Jan 2020
편집: KALYAN ACHARJYA 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.

  댓글 수: 1

Ahmad Fakih
Ahmad Fakih 17 Jan 2020
Thanks, it works!

로그인 to comment.

추가 답변(0개)

이 질문에 답변하려면 로그인을(를) 수행하십시오.

태그


Translated by