concatenate matrixs

2 次查看（过去 30 天）
li xinjun
li xinjun 2011-12-7
I have two matrixs:one is num,the other is str.Like Num1=[1,2.32322232,4;222,0,-Inf],char1=['A1';'A2'].I want concatenate them,and use 'xlswrite' to save them in a excel. My steps:
Num1=[1,2.32322232,4;222,0,-Inf];
char1=['A1';'A2'];
w=str2num(char1);
w=[w;Num1;];
xlswrite('excel',w);
But it shows : ??? Error using ==> vertcat CAT arguments dimensions are not consistent. How can I do?
  1 个评论
li xinjun
li xinjun 2011-12-7
And also,I need Num1=[1,2.32322232,4;222,0,-Inf] show like [1.00,2.32,4.00;222.00,0.00,-Inf] in the excel.I know the length of each elements between char1 and Num1 are not the same ,even each elements of the Num1 isn't the same longth,but I also hope I can achieve.

请先登录，再进行评论。

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-12-7
Because you have mixed numerical and string data, you have to make your variable w a cell array if you just want to run xlswrite() once. One way to come up with the cell array with your desired format for numerical data is below.
%%Original data
Num1=[1,2.32322232,4;222,0,-Inf];
char1=['A1';'A2'];
w=textscan(sprintf('%10.2f,',Num1),'%s','delimiter',',');
w=[cellstr(char1), reshape(w{1},size(Num1,1),size(Num1,2))];
xlswrite('ExcelFile.xls',w);

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by