Transforming cell from excel file into numeric matrix

1 回表示 (過去 30 日間)
Ahmad Fakih
Ahmad Fakih 2020 年 1 月 17 日
コメント済み: Ahmad Fakih 2020 年 1 月 17 日
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 件のコメント
Stephen23
Stephen23 2020 年 1 月 17 日
Using a table seems superfluous, did you try readmatrix?:
Ahmad Fakih
Ahmad Fakih 2020 年 1 月 17 日
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 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by