reading text and number from excel

87 次查看（过去 30 天）
farfar
farfar 2019-1-18
编辑： per isakson 2019-1-19
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
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!

Translated by