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

27 次查看（过去 30 天）
MathWorks Support Team
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?

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

采纳的回答

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)

更多回答（0 个）

类别

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

标签

产品


版本

R2008a

Community Treasure Hunt

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

Start Hunting!

Translated by