MATLAB: Convert cell to string

cellconvertstring

I have a cell (721*1), each cell composed by a different number of string, for example, the first cell is a (1*20) string. I want to convert this cell to string. when I use string function, it reported an error as "Conversion from cell failed. Element 1 must be convertible to a string scalar.". I have no idea why it can't convert as the string function described in Matlab.

Best Answer

So what is that conversion from cell array to string supposed to do? What do you want as an output?

Assuming it's a 1xN string array that is simply the concatenation of all the string arrays in your cell array, then:

sarray = [A{:}]

The above will fail if at least one string array in any cell does not have the same number of rows as all the other string arrays.

Related Solutions

MATLAB: Converting cell array full of characters to a string

How about:

A = {'the';'quick';'brown';'fox'}
char(A)

char(cellfun(@transpose,A,'uni',false))

etc depending on how you want to convert it.

MATLAB: Writting strings to Excel

Your Labels is not a cell array of strings, despite the fact that your comment claims that. It's a character array and will therefore put one character into each Excel cell like what you're observing. You need to make it a cell array

Labels = {PLabels; SLabels};  % Note braces, not brackets.

Try that and let me know how it worked. Here's a complete demo with 3 cases to see how they work differently:

% This code works just fine.
PLabels = {'aaa', 'bbbb'} % Row vector cell array with 2 columns.

SLabels = {'ccc', 'dddd'} % Row vector cell array with 2 columns.
% Vertically concatenate the two row vectors into a single 2 by 2 cell array.
Labels = [PLabels;SLabels]; % 2 by 2 cell array of strings (two cell array joined)
xlswrite('delete me 1.xlsx',Labels,'Caract.Gnls.','A3');
% Case #2
% This code does not.
PLabels = ['aaa', 'bbbb'] % A single string 'aaabbbb'

SLabels = ['ccc', 'dddd'] % A single string 'cccdddd'

Labels = [PLabels;SLabels]; % Character array of strings
xlswrite('delete me 2.xlsx',Labels,'Caract.Gnls.','A3');
% Case #3
% This code also works just fine, but differently than case #1.
PLabels = ['aaa', 'bbbb'] % A single string 'aaabbbb'
SLabels = ['ccc', 'dddd'] % A single string 'cccdddd'
Labels = {PLabels; SLabels}; % Note braces instead of brackets.
xlswrite('delete me 3.xlsx',Labels,'Caract.Gnls.','A3');

I also highly recommend you re-read this section of the FAQ to get an intuitive feeling with how to deal with cell arrays: http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F

Best Answer

Related Solutions

MATLAB: Converting cell array full of characters to a string

MATLAB: Writting strings to Excel

Related Question