Mixed data types cell to string

7 次查看（过去 30 天）
Daniel Kin
Daniel Kin 2013-4-10
Using xlsread I read the a spreadsheet
[ndata, text, alldata] = xlsread(filename);
One cloumn of alldata is a mixed data types as shown below (strings and integers). As I wish to use it for further analysis, is it possible to convert all this cell to be strings?
Thanks.
Cell output:
'NoGroup'
'NoGroup'
'NoGroup'
[1]
[1]
[1]
[2]
[2]
[2]
[2]
[2]
[2]
'Group3'
'Group3'
'Group3'

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

采纳的回答

Jan
Jan 2013-4-10
C = {'NoGroup', 1; 2; 'Group3'};
for iC = 1:numel(C)
if ~ischar(C{iC});
C{iC} = num2str(C{iC});
end
end
There are alternatives like cellfun('isclass', C, 'char') or sprintf('%g', C[iC}).

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by