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

16 次查看（过去 30 天）

michio 2019-10-18

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/486029-exported-formulas-on-excel-sheets-resulted-in-text-which-would-not-be-evaluated-automatically

评论： Alex Calder 2022-11-2

According to the past post, simply using xlswrite and writecell to export formula as text (char/string) will result in formulas in Excel.

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

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2019-10-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/486029-exported-formulas-on-excel-sheets-resulted-in-text-which-would-not-be-evaluated-automatically#answer_396967

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.

7 个评论
显示 5更早的评论隐藏 5更早的评论

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)

Alex Calder 2022-11-2

So do I understand correctly, that there is no solution for environments without Excel installed? I have a managed Linux environment that uses Open Office, rather than Excel.

请先登录，再进行评论。