concatenating characters in different column to a string
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuesta aceptada
Walter Roberson
el 4 de Jun. de 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 comentarios
Más respuestas (1)
Image Analyst
el 4 de Jun. de 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 comentarios
Ver también
Categorías
Más información sobre Cell Arrays en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!