Transforming cell from excel file into numeric matrix

3 visualizaciones (últimos 30 días)
Ahmad Fakih
Ahmad Fakih el 17 de En. de 2020
Comentada: Ahmad Fakih el 17 de En. de 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 comentarios
Stephen23
Stephen23 el 17 de En. de 2020
Using a table seems superfluous, did you try readmatrix?:
Ahmad Fakih
Ahmad Fakih el 17 de En. de 2020
I think readmatrix is exclusive to 2019b version, mine is 2018a :(

Iniciar sesión para comentar.

Respuesta aceptada

KALYAN ACHARJYA
KALYAN ACHARJYA el 17 de En. de 2020
Editada: KALYAN ACHARJYA el 17 de En. de 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.

Más respuestas (0)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by