Transforming cell from excel file into numeric matrix

3 Ansichten (letzte 30 Tage)
Ahmad Fakih
Ahmad Fakih am 17 Jan. 2020
Kommentiert: Ahmad Fakih am 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 Kommentare
Stephen23
Stephen23 am 17 Jan. 2020
Using a table seems superfluous, did you try readmatrix?:
Ahmad Fakih
Ahmad Fakih am 17 Jan. 2020
I think readmatrix is exclusive to 2019b version, mine is 2018a :(

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

KALYAN ACHARJYA
KALYAN ACHARJYA am 17 Jan. 2020
Bearbeitet: KALYAN ACHARJYA am 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.

Weitere Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by