Clear Filters
Clear Filters

How do you get matlab to import/read a column vector of strings or characters??

8 views (last 30 days)
How do you get matlab to import a column vector of strings or characters??
[zone]=xlsread('Tox_model.xlsx',2,"E5:E10");
E5-E10 reads like this in excel:
s1
s2
s3
s2
s3
s1
In reality the colum vector is very long (1000s) and not just a (1:5) vector ...
The variable is empty when I run the code. Why???

Accepted Answer

David Hill
David Hill on 27 Jan 2021
Did you try reading into a cell array?
zone=readcell('Tox_model.xlsx');
  5 Comments
David Hill
David Hill on 28 Jan 2021
m=readmatrix('Tox_model.xlsx','Sheet','PWS PFHxS Conc','Range','D5:L102');%much easier to read into a matrix and use indexing
a=readcell('Tox_model.xlsx','Sheet','Participants'' water intake ','Range','E5:E102');
k={'s1','s2','s3','w1','w23','w4','w5','f1','f2','sh'}
for n=1:length(a)
WatCon(n)=m(n,ismember(k,a(n)));%there are several 's0','s5','s4' listed in array that do not correspond
end

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!