MATLAB Answers

Exported formulas on excel sheets resulted in text which would not be evaluated automatically

16 ビュー (過去 30 日間)
michio
michio 2019 年 10 月 18 日
コメント済み: michio 2019 年 10 月 28 日
According to the past post, simply using xlswrite and writecell to export formula as text (char/string) will result in formulas in Excel.
However executing the following on R2019a, Windows 10.
a={'1','2','=sum(a1,b1)'}
a(2,:)={'4' '5' '=sum(a2,b2)'}
a(3,:)={4, 5 ,'=sum(a3,b3)'}
% xlswrite('Book.xls',a)
writecell(a,'Book.xls')
creates the following.
Do we need any set-up on Excel side or is there anything that can be done from MATLAB side? Using ActiveX is of course an option, but I'm looking for simpler option.

  0 件のコメント

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

採用された回答

Walter Roberson
Walter Roberson 2019 年 10 月 18 日
That post does not say that the formulas will be executable once written by xlswrite.
None of the table based operations such as writetable or writecell are able to create executable formulas. You will need to use ActiveX methods.

  6 件のコメント

表示 3 件の古いコメント
Image Analyst
Image Analyst 2019 年 10 月 18 日
So I guess the key is to have an extension of .xlsx rather than .xls.
michio
michio 2019 年 10 月 18 日
It was indeed for xlswrite, but neither of them works (as in the formulas executable) with writecell.
michio
michio 2019 年 10 月 28 日
Setting 'UseExcel' to true resolves the issue with writecell.
a={'1','2','=sum(a1,b1)'}
a(2,:)={'4' '5' '=sum(a2,b2)'}
a(3,:)={4, 5 ,'=sum(a3,b3)'}
writecell(a,'Book.xls','UseExcel',true)

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

その他の回答 (0 件)

製品


リリース

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by