Converting letters to strings

Question

antonet 2014-2-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/118225-converting-letters-to-strings

回答： Image Analyst 2014-2-25

Dear Matlab users

I read some data from an excel file. The column 11 of this file contains

 Baa1
Ca
Baa
B
Aaa

and so forth. When I use

 raw=xlsread('file.xlsx');
K=raw(:,11)

I get NaN for each element of K. My questions is how to convert column 11 to a column of string variables. Note that my column is of dimension 20000 by 1. Is there a command in Matlab to do that?

Thanks in advance

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

per isakson 2014-2-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/118225-converting-letters-to-strings#answer_125648

编辑：per isakson 2014-2-23

The documentations says:

[ num, txt, raw ] = xlsread( filespec );

Thus try

[~,~,raw] = xlsread('file.xlsx');

Now, K will contain the column of strings. You could also use the argument, txt, but then the column number might be "shifted" depending on whether there are numerical columns to the left (C<=10).

"column of string variables" do you mean a character array or a cell array of strings?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Image Analyst 2014-2-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/118225-converting-letters-to-strings#answer_126098

If you have R2013b you should use readtable() instead of xlsread(). It's so so much easier. Instead of all that nonsense of 3 cell arrays, which aren't even matched up as far as rows and columns go, you get a simple and intuitive "table" - which is a new variable class in R2013b that I encourage everyone to try.

ONCE YOU TRY readtable(), YOU'LL PROBABLY NEVER USE xlsread() EVER AGAIN.

Another use of the table is to use with regionprops() and struct2table() to create a table instead of an array of structures. I'll contact the Image Processing team to see if they can make a table an option directly instead of having to use struct2table.