MATLAB: Can we use Xlswrite in symbolic variables

symbolic variablesxlswrite

I have a matrix (for example [B]) which it includes symbolic variables in its rows.

So I want to transfer it to Excel , is it possible?

Best Answer

syms x_1 y_1
A_sym = sym(zeros(2,2)); 
A_sym(1,1) = x_1; 
A_sym(2,1) = x_1 * y_1 ; 
A_sym(2,2) = y_1;
sym_cell = arrayfun(@char,A_sym, 'uniform', 0) ;
xlswrite('test.xlsx',sym_cell)

Related Solutions

MATLAB: XLSWRITE

name = inputdlg('Name excel file as: ','Name excel',1);

MATLAB: Xlswrite

Hi Nasir,

Is the value of A a scalar? Even if you could make this work, writing to an Excel file at every loop iteration sounds like slow going. How about preserving the values of A within MATLAB itself:

 allA = zeros(numLoopIterations, 1);
 for i=1:numLoopIterations
   A = ...
   allA(i) = A;
 end
 plot(allA)

I've pre-allocated above for performance reasons, but I suspect even not pre-allocating (if numLoopIternations is not known, for example) will be much faster than writing to Excel:

 allA = [];
 while ...
   A = ...
   allA(end+1) = A;
 end
 plot(allA)

Best Answer

Related Solutions

MATLAB: XLSWRITE

MATLAB: Xlswrite

Related Question