MATLAB Answers

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

55 ビュー (過去 30 日間)
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
MathWorks Support Team 2009 年 6 月 27 日
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 件のコメント

サインインしてコメントする。

その他の回答 (0 件)

製品


リリース

R2008a

Community Treasure Hunt

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

Start Hunting!

Translated by