Transforming cell from excel file into numeric matrix
조회 수: 4 (최근 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
채택된 답변
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 Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!