concatenating characters in different column to a string

Question

Rinachi Garg 2012-6-4

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/40271-concatenating-characters-in-different-column-to-a-string

I want to store 1x5 array of strings ['a' 'b' 'c' 'd' 'e'] as a single string of 1x1 :'abcde'. How can I do that? I want to do this because if I export ['a' 'b' 'c' 'd' 'e'] to excel file then they appear in seperate columns. But I want to write them all in same cell.

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2012-6-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/40271-concatenating-characters-in-different-column-to-a-string#answer_49898

['a' 'b' 'c' 'd' 'e'] is not a 1 x 5 array of strings: it is a single string of length 5, 'abcde', exactly as you want.

{'a' 'b' 'c' 'd' 'e'} on the other hand would be a 1 x 5 cell array of strings. You can convert this cell array to a single string by using cell2mat()

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

请先登录，再进行评论。

Answer 2

Image Analyst 2012-6-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/40271-concatenating-characters-in-different-column-to-a-string#answer_49902

在 MATLAB Online 中打开

Try this:

% Create sample data.
charArray = ['a' 'b' 'c' 'd' 'e']
% Turn it into a cell array.
myCellArray = {charArray}
% Write to cell c3 of Excel.
sheetNumber = 1;
cellReference = 'C3';
xlswrite('test_sheet.xls', myCellArray, sheetNumber, cellReference);