How do you get matlab to import/read a column vector of strings or characters??
2 次查看(过去 30 天)
显示 更早的评论
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???
0 个评论
采纳的回答
David Hill
2021-1-27
Did you try reading into a cell array?
zone=readcell('Tox_model.xlsx');
5 个评论
David Hill
2021-1-28
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
更多回答(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!