reading text and number from excel
조회 수: 75 (최근 30일)
이전 댓글 표시
Hello
I have this big excel file incuding text and numbers. when I use t= xlsread('table.xlsx'); it removes the columns with string automatically. when I use t = readtable('table.xlsx'); I am able to see the whole table. however, I fail to do my main job which is plotting different columns versus others . what command should i use to be able read from a table including text and number and be able to do all regular matrix function? Thanks !
t = readtable('table.xlsx')
a=t(:,4)
b=t(:,6)
plot (a,b, '.')
lsline
댓글 수: 2
per isakson
2019년 1월 18일
편집: per isakson
2019년 1월 18일
See
[num,txt,raw] = xlsread(___)
in the documentation and try
a=t{:,4}
b=t{:,6}
답변 (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!