reading text and number from excel
81 views (last 30 days)
Show older comments
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 Comments
per isakson
on 18 Jan 2019
Edited: per isakson
on 18 Jan 2019
See
[num,txt,raw] = xlsread(___)
in the documentation and try
a=t{:,4}
b=t{:,6}
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!