how to "write" a equation like string from a number matrix and a vector of varibles, and put those equation into cell to slxwrite to excel ?

Question

Tien Phat Ngo Nguyen 2015-12-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/260294-how-to-write-a-equation-like-string-from-a-number-matrix-and-a-vector-of-varibles-and-put-those-e

评论： Tien Phat Ngo Nguyen 2015-12-15

I have a vector of name of variables like 'cake' 'sandwich' 'key' 'sun' etc, and a matrix of n x m coeff. I need to combine each row of the matrix with the vector (sort of like what a bsxfun(@times,matrix, vector) do if the vector is numeric). They should become a vector of n equations like 0.01*cake-0.5*sandwich+10*key (with no space and the '*' character included). I've been searching a lot, but with no proper knowledge of matlab I can't find anything. Noted the matrix is taken from a system of linear equations, but if I have to write them all back is would be fruitless since the matrix usually huge and there are many of them :(. And slxwrite them back into excel too. Please help me.

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

请先登录，再进行评论。

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

Answer 1

jgg 2015-12-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/260294-how-to-write-a-equation-like-string-from-a-number-matrix-and-a-vector-of-varibles-and-put-those-e#answer_203230

在 MATLAB Online 中打开

Something like this should do it:

A = magic(2);
 c = cell(1,2);
 c{1} = 'cat';
 c{2} = 'winter';
 out = cell(2,1);
 for j = 1:2
    str = '';
  for i = 1:2
      if i < 2
        str = strcat(str,mat2str(A(j,i)),'*',c{i},'+');
      else
        str = strcat(str,mat2str(A(j,i)),'*',c{i});
      end
  end
   out{j} = str;
 end