Will it be possible to use XLSWRITE to write formulas to the excel sheet which would be calculated altomatically when they are written?

I need to create an XLS sheet from MATLAB using the XLSWRITE command. However, I want to export data and the cell formulas to the xls sheet

For example, I might want to write to a cell:

 cell F5: =sum(F1:F4)

Would this be possible when I use the XLSWRITE Command?

Answer 1

[MathWorks Support Team]

You can write formulas to cells as regular strings. Below are some commands that can be used for declaring a cell array and then writing it to Excel.

a={'1','2','=sum(a1,b1)'}

a(2,:)={'4' '5' '=sum(a2,b2)'}

a(3,:)={4, 5 ,'=sum(a3,b3)'}

xlswrite('Book2.xls',a)