Transforming cell from excel file into numeric matrix

1 vue (au cours des 30 derniers jours)
Ahmad Fakih
Ahmad Fakih le 17 Jan 2020
Commenté : Ahmad Fakih le 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 commentaires
Stephen23
Stephen23 le 17 Jan 2020
Using a table seems superfluous, did you try readmatrix?:
https://www.mathworks.com/help/matlab/ref/readmatrix.html
Ahmad Fakih
Ahmad Fakih le 17 Jan 2020
I think readmatrix is exclusive to 2019b version, mine is 2018a :(

Connectez-vous pour commenter.

Connectez-vous pour répondre à cette question.

Réponse acceptée

KALYAN ACHARJYA
KALYAN ACHARJYA le 17 Jan 2020
Modifié(e) : KALYAN ACHARJYA le 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.

Plus de réponses (0)

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by