concatenating characters in different column to a string
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Walter Roberson
le 4 Juin 2012
['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 commentaires
Plus de réponses (1)
Image Analyst
le 4 Juin 2012
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);
0 commentaires
Voir également
Catégories
En savoir plus sur Cell Arrays dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!